Re: what is the syntax for finding a rowid ?

thank you

"Alexei VORONOV" <alexei_voronov_at_yahoo.com> wrote in message news:9r9dbp$slb$1_at_wanadoo.fr...
> See DBMS_ROWID
> There are several functions to retrieve information you want.
> e.g.
> select DBMS_ROWID.ROWID_OBJECT(ROWID) from <Your table>;
> select DBMS_ROWID.ROWID_ROW_NUMBER(ROWID) from <Your table>;
> etc.
>
> See 2-18 in the "Oracle SQL Reference" also.
>
Received on Thu Oct 25 2001 - 12:12:45 CDT