Tipworld -> SQL
Deciphering Oracle Rowid

An Oracle Rowid needs to be deciphered using Oracle built-in functions. Without these functions, the Rowid is unintelligible (unless the Rowid is in the older, restricted format). To get the row number, block number, and file number, use the DBMS_ROWID package as shown below:

Select DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid), DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO(rowid), DBMS_ROWID.ROWID_ROW_NUMBER(rowid),
from table_name
where table_key = id1;

This will return information similar to the following:

Block File Row
321 52 4