SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert this simple query to procedure for custom paging

455054May 27 2010 — edited May 31 2010

How can I conver this to procedure to work with custom paging. I used .net and It is really difficult to find a sample code in the web for oracle and .net. I really apprciate if you point me to the place where i can find a sample code
for oracle and .net for custom paging.

I am trying to create a custom paging for my .net page. I am using oracle 10g. thank you for your help.

SELECT cdescr, clocat1, cprojnum, cont
  FROM (SELECT                                           /**+ first_row(25) */
               cdescr, clocat1, cprojnum,
               ROW_NUMBER () OVER (ORDER BY contid) cont
          FROM proposal)
 WHERE cont BETWEEN :n AND :m

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2010

Added on May 27 2010

5 comments

1,179 views