SQL> declare

  2  v_rowid_type number;

  3  v_object_number number;

  4  v_relative_fno number;

  5  v_block_number number;

  6  v_row_number number;

  7  begin

  8

  dbms_rowid.rowid_info('AAAO8jAAEAAAcbAAAB',v_rowid_type,v_object_number,v_relative_fno,v_block_number,v_row_number);

  9  dbms_output.put_line(v_rowid_type);

 10  dbms_output.put_line(v_object_number);

 11  dbms_output.put_line(v_relative_fno);

 12  dbms_output.put_line(v_block_number);

 13  dbms_output.put_line(v_row_number);

 14  end;

 15  /

1

61219

4

116416

1

PL/SQL procedure successfully completed

小记：

　　ORACLE的包直接使用即可，不用select oracle的预定义包．之前我一直有这个错觉．特为记．