select rowid,
dbms_rowid.rowid_object(rowid) data_object_id#,
dbms_rowid.rowid_relative_fno(rowid) file#,
dbms_rowid.rowid_block_number(rowid) block#,
dbms_rowid.rowid_row_number(rowid) row#,
b.emp_id,
B.EMP_NAME
from dim_employee b
---where b.rowid='AAAQwWAAEAAAhvfAAD'
dbms_rowid.rowid_object(rowid) data_object_id#,
dbms_rowid.rowid_relative_fno(rowid) file#,
dbms_rowid.rowid_block_number(rowid) block#,
dbms_rowid.rowid_row_number(rowid) row#,
b.emp_id,
B.EMP_NAME
from dim_employee b
---where b.rowid='AAAQwWAAEAAAhvfAAD'