Oracle11g之实用技术--将数据插入Oracle数据库时如何得到其rowId

lemonlili

CREATE OR REPLACE  PROCEDURE ROWIDGET (ROWIDGET VARCHAR2)
IS
ROWIDIN VARCHAR2(100);
ROWIDTYPE NUMBER;
ROWIDOBJECT NUMBER;
RELATIVENO NUMBER;
BLOCKNUM NUMBER;
ROWNUM NUMBER;
BEGIN
ROWIDIN:=ROWIDGET;
DBMS_ROWID.ROWID_INFO(ROWIDIN,ROWIDTYPE,ROWIDOBJECT,RELATIVENO,BLOCKNUM,ROWNUM);
DBMS_OUTPUT.PUT_LINE('TYPE '||ROWIDTYPE||'  OBJECTID '||ROWIDOBJECT||'    FILE '||RELATIVENO||'   BLOCKID '||BLOCKNUM||'  ROWNUM '||ROWNUM);
END;
/

通过ROWID  来获得 ROW的信息
scott@ORA>  exec rowidget('AAAMfPAAEAAAAAgAAN')
TYPE 1  OBJECTID 51151    FILE 4   BLOCKID 32  ROWNUM 13

dingning239

学习了，感谢各位大侠