Re: Rownum

One possible approach is to create a transient table for the results, and number each row as it goes into the table. Then you can select rows by the rownumber you have created.

Obviously it is not very desirable to keep creating and dropping tables, although 'create as select unrecoverable' is not too heavy on redo, so ..

You could keep a set of permanent tables, and log of current state, and allocate a table to a session etc, only creating a new table if you run short, and perhaps de-allocating a table from a session if the log shows the session to be over 24 hours since last action.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Sue French wrote in message <7AlX2.283$vO1.17284_at_news.tcp.co.uk>...
>For an intranet application, I need to fetch say 10 records. I can do this
>by specifiying "WHERE ROWNUM < 11".
>
>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.
Received on Mon May 03 1999 - 13:37:06 CDT