Re: what is the syntax for finding a rowid ?

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Thu, 25 Oct 2001 18:08:34 +0200
Message-ID: <9r9dbp$slb$1@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.

"bullseye" <bullseye35_at_deletethefunnies@excite.com> a écrit dans le message news: kpWB7.51504$n5.6712391_at_typhoon.nyc.rr.com...
> If I may amend the question, what is the syntax in 8i to find the rowid,
> block, and other info in numbers (rather than the lettered representation
of
> the hexadecimal)?
>
> "bullseye" <bullseye35_at_deletethefunnies@excite.com> wrote in message
> news:drVB7.3432$XA5.2176965_at_typhoon.nyc.rr.com...
> >
> >
> >
> >
>
>
Received on Thu Oct 25 2001 - 11:08:34 CDT