<SPAN
class=107272408-07062001>Hi all,
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>I was just wondering if there is any alternative method
of getting the numeric values of rowid other than
dbms_rowid.
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>Other way, what is the algorithm for calculating
numeric value of rowid's values. e.g.
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>SQL> SELECT DISTINCT SUBSTR(ROWID,10,6) BLOCK# FROM
PRASANTA.TPSV ;
<SPAN
class=107272408-07062001>BLOCK#------AAAmQa
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>SQL> SELECT DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
BLOCK FROM 2 PRASANTA.TPSV ;
<SPAN
class=107272408-07062001>
BLOCK---------- 156698
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>Now, how can I relate AAAmQa and 156698
??
<SPAN
class=107272408-07062001>Was this package DBMS_ROWID existing on Oracle 7.x
??
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>Thanks for your inputs...
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>Cheers,
<SPAN
class=107272408-07062001>Rajesh
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>
<SPAN
class=107272408-07062001>
Received on Thu Jun 07 2001 - 05:32:38 CDT
