Re: SQL Query
From: Charles Johnson <charjohn_at_usa.capgemini.com>
Date: 1999/10/07
Message-ID: <37fcf116_2_at_news1.prserv.net>#1/1
Date: 1999/10/07
Message-ID: <37fcf116_2_at_news1.prserv.net>#1/1
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 - 00:00:00 CEST