Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_ROWID equivalent for Oracle 7??

Re: DBMS_ROWID equivalent for Oracle 7??

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 8 Sep 2000 06:29:20 +0200
Message-ID: <968387863.6317.4.pluto.d4ee154e@news.demon.nl>

There is none as the v7 rowid is composed of that info (except for the objectid)

Hth,

Sybrand Bakker, Oracle DBA

"Andy Hardy" <aph_at_ahardy.demon.co.uk> wrote in message news:3xfP+gA+4Au5EwpE_at_ahardy.demon.co.uk...
> Hi,
>
> I'm want to find a row/rowid from an object_id, file number, block
> number and row number (I'm looking at locked rows through v$session and
> v$lock).
>
> Oracle 8 has the dbms_rowid facility to do this, what is the Oracle 7
> equivalent?
>
> Andy
> --
> Andy Hardy. PGP ID: 0xA62A4849
> ===============================================================
Received on Thu Sep 07 2000 - 23:29:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US