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.