Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's the meaning of ROWID?
Hi Jimmy
Rowid is an implicit columns created for each row in the table. It is made up of 3 components namely, file number, block number and row number. Yes it would be unique for each row in the table but there is no guarantee that the last row added in the table would have the largest rowid.
Hope this helps,
Ketan Shah
In article <34FB18DE.4D49_at_comp.polyu.edu.hk>,
Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:
>
> Hello all,
>
> Could anyone tells me what is the meaning of rowid? Is rowid unique
> with each record in a table? Is the lastest record with the largest
> rowid in a table?
>
> Thanks,
> Jimmy
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 02 1998 - 00:00:00 CST