Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> How to use ROWNUM
Dear all
I have a very large table.
And the content in this table will be display in Web page.
(using ADO + ODBC)
Since the size of table is too big, I wish to display all tuples page by page.
I found 'rownum' command in oracle document. however, the following command is not worked.
select ...
from ...
where rownum between 100 and 200;
this command return no rows ....
can somebody help me .... Received on Sat Apr 08 2000 - 00:00:00 CDT