DBMS_ROWID

Summary of DBMS_ROWID Subprograms

Table 111-5 DBMS_ROWID Package Subprograms

 

Subprogram	Description
ROWID_BLOCK_NUMBER Function	Returns the block number of a ROWID
ROWID_CREATE Function	Creates a ROWID, for testing only
ROWID_INFO Procedure	Returns the type and components of a ROWID
ROWID_OBJECT Function	Returns the object number of the extended ROWID
ROWID_RELATIVE_FNO Function	Returns the file number of a ROWID
ROWID_ROW_NUMBER Function	Returns the row number
ROWID_TO_ABSOLUTE_FNO Function	Returns the absolute file number associated with the ROWID for a row in a specific table
ROWID_TO_EXTENDED Function	Converts a ROWID from restricted format to extended
ROWID_TO_RESTRICTED Function	Converts an extended ROWID to restricted format
ROWID_TYPE Function	Returns the ROWID type: 0 is restricted, 1 is extended
ROWID_VERIFY Function	Checks if a ROWID can be correctly extended by the ROWID_TO_EXTENDED function

example

select DBMS_ROWID.ROWID_OBJECT(rowid) "OBJECT",

DBMS_ROWID.ROWID_RELATIVE_FNO(rowid) "FILE",

DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) "BLOCK",

DBMS_ROWID.ROWID_ROW_NUMBER(rowid) "ROW"

from t1 where rowid = 'AAAMijAAFAAAAAPAAS';

 

 OBJECT         FILE      BLOCK       ROW

---------- ---------- ---------- ----------

    258                1           2082           0

 

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_rowid.htm