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

Home -> Community -> Usenet -> c.d.o.tools -> How to use ROWNUM

How to use ROWNUM

From: Vincent Chen <vincent_at_iuhua.com.tw>
Date: 2000/04/08
Message-ID: <8cmnnb$stp$1@news1.sinica.edu.tw>#1/1

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

Original text of this message

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