Re: How to use ROWNUM

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: 2000/04/08
Message-ID: <8cnj0j$rkp$4@news5.svr.pol.co.uk>#1/1

Rownum gets only allocated when retrieving a row. So unless you fetch the first row you never see rownums higher than 1.

You could use the following inline view:

select * from

(select rownum mycount, mytable.* from mytable) where mycount between 100 and 200

Regards,

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE


Vincent Chen <vincent_at_iuhua.com.tw> wrote in message
news:8cmnnb$stp$1_at_news1.sinica.edu.tw...


> 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