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: A RowId in Oracle 8i

Re: A RowId in Oracle 8i

From: Uchakra <uchakra_at_aol.com>
Date: 04 Feb 2001 05:29:51 GMT
Message-ID: <20010204002951.16835.00000626@ng-cr1.aol.com>

Use

dbms_rowid.rowid_to_restrcted(rowid,0)

Example:

In 7.3.4
select rowid from table_name ;

In 8 and higher

select dbms_rowid.rowid_to_restricted(rowid,0) from table_name ;

Hope this helps

Regards
Willy Received on Sat Feb 03 2001 - 23:29:51 CST

Original text of this message

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