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的预定义包.之前我一直有这个错觉.特为记.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-731627/,如需转载,请注明出处,否则将追究法律责任。