dbms_rowid

来源:互联网 发布:水果机辅助软件助手 编辑:程序博客网 时间:2024/06/07 03:32
select dbms_rowid.rowid_object(rowid) object_id,
       dbms_rowid.rowid_relative_fno(rowid) file_id,
       dbms_rowid.rowid_block_number(rowid) block_id,
       dbms_rowid.rowid_row_number(rowid) num,
       t.*
  from t
--  where dbms_rowid.rowid_block_number(rowid) = '267443'
 order by 2, 3, 4
原创粉丝点击