If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

And the use of rownum, which is a pseudo column, won't always return the same rows. It depends on what else you are doing (sort, order, group by, having, and doing nothing to sort the data may return entirely different rows). If you don't care which 10 rows come out, then what Ao wrote will work for you.

Also, you can only do "where rownum=1" or "where rownum < some_number." For example, you can't do "where rownum=5."

When I ran query with table having 25 Columns .The Query runs for quite a long time .Also I had to use Control-c to stop it.It does display error msg.Is there any set parameter to be used for query listing to page by page.Do I need to chk for something.