oracle 根据rowid得到行所在的对象号,数据文件号,块号,行编号。
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,
posted on 2016-02-09 15:30 wangxingc 阅读(246) 评论(0) 编辑 收藏 举报