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 |