Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rownum

Rownum

From: Sue French <sfrench_at_tcp.co.uk>
Date: Mon, 3 May 1999 19:05:09 +0100
Message-ID: <7AlX2.283$vO1.17284@news.tcp.co.uk>


Can anyone help me with Rownum?

For an intranet application, I need to fetch say 10 records. I can do this by specifiying "WHERE ROWNUM < 11".

However, I then want to fetch either the next ten or the previous 10 rows. I thought I would be able to say "WHERE ROWNUM > 10 and ROWNUM < 20", but this returns no rows.

I have to avoid using cursors, because this is causing no end of problems, so I really need to connect to the database, fetch the 10 records then disconnect and subsequently connect and disconnect when the next/previous 10 are requested.

Regards

Sue French



Visit me at http://homepages.tcp.co.uk/~sfrench/ See you there! Received on Mon May 03 1999 - 13:05:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US