Re: SQL Query

From: Charles Johnson <charjohn_at_usa.capgemini.com>
Date: Thu, 7 Oct 1999 14:07:48 -0500
Message-ID: <37fcf116_2@news1.prserv.net>

George,

Oracle provides two psedocolumns ROWID and ROWNUM. ROWID returns the rowids of rows in a table. ROWNUM returns the row number of the rows in a query. ROWID is an 18-character string (somewhat cryptic) and ROWNUM is a sequential number. I think ROWNUM may be what you are looking for.

Hope this helps.

Charles J.

George Wilson Mathias wrote in message <37FCCD3C.6B0024E9_at_mci.com>...
>Hello there,
>
>How can I select batch of rows from a table ? I mean If I a table with
>1000 rows, how can I selects rows from 100 to 200 or 500 to 600 ?
>
>Thanks
>George Mathias
>
Received on Thu Oct 07 1999 - 14:07:48 CDT