查询rowid行数据所对应的数据对象编号,文件编号,块编号和行编号

select rowid,
substr(rowid,1,6)||' : '||dbms_rowid.rowid_object(rowid)  数据对象编号,
substr(rowid,7,3)||' : '||dbms_rowid.rowid_relative_fno(rowid) 文件编号,
substr(rowid,10,6)||' : '||dbms_rowid.rowid_block_number(rowid) 块编号,
substr(rowid,16,3)||' : '||dbms_rowid.ROWID_ROW_NUMBER(rowid) 行编号
,a,b
from test

转载于:https://blog.51cto.com/fmeng/1343902