ROWID_BLOCK_NUMBER
This function shows the block number for the given rowed.
Example:
select id,name,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) from emp;
This function shows the block number for the given rowed.
Example:
select id,name,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) from emp;