Re: record number?

From: <breuere_at_yahoo.com>
Date: 24 Apr 2001 23:46:31 GMT
Message-ID: <9c538n$t0c$1_at_news.netmar.com>


You can always try

select * from
(select empty.*, rownum as rn from empty where rownum <= 2) where rn = 2

In article <3992EC0C.29ADDBEA_at_wxs.nl>, =?iso-8859-1?Q?Andr=E9=20Kl=FCck?= <akluck01_at_wxs.nl> writes:
>Igor,
>
>No way!
>There is the ROWID, but Oracle itself will determite wich order the rows are
>stored.
>Most of the time it will be in the same order as you insert them (committed
>per row).
>But after export and import things look very different, after reorganizing
>the table too.
>
>sUCCess
>
>SELECT ROWID, column_name
>FROM table
>ORDER BY column_name
>
>After you know which ROWID belongs to the wanted column_name, you can
>
>SELECT *
>FROM table
>WHERE ROWID = 'xxxxxxxxxxxxxxxx'
>
>Remember: someone else could mess things up for you.
>
>"Igor Apostoloski ()" wrote:
>
>> is there some way to determine the record number with a query in oracle?
>>
>> example:
>> database is empty
>> I append row a, row b and then row c
>>
>> I want a way to do the following :
>>
>> show row 2
>>
>> and the row b should be displayed.
>>
>> thanks.
>

  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Wed Apr 25 2001 - 01:46:31 CEST

Original text of this message