RE: decoding rowids

<SPAN
class=740282408-08062001>Nope..not in my 7.3.2. ...

<FONT face=Tahoma

  size=2>-----Original Message-----From: Rajesh Dayal   [mailto:Rajesh_at_ohitelecom.com]Sent: Thursday, June 07, 2001 5:28   PMTo: Multiple recipients of list ORACLE-LSubject:   decoding rowids
<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 Fri Jun 08 2001 - 04:52:57 CDT