转-获取数据行的详细信息函数

create or replace function get_rowid
(l_rowid in varchar2)
return varchar2
is
ls_my_rowid  varchar2(200);         
rowid_type  number;         
object_number  number;         
relative_fno  number;         
block_number  number;         
row_number  number; 
begin
 dbms_rowid.rowid_info(l_rowid,rowid_type,object_number,relative_fno, block_number, row_number);         
 ls_my_rowid := 'Object# is      :'||to_char(object_number)||chr(10)||
  'Relative_fno is :'||to_char(relative_fno)||chr(10)||
  'Block number is :'||to_char(block_number)||chr(10)||
  'Row number is   :'||to_char(row_number);
 return ls_my_rowid ;
end;         
/

SQL> select rowid,id from test;

ROWID                      ID
------------------ ----------
AAATMDAAEAAAAo2AAA         10
AAATMDAAEAAAAo2AAB         20

SQL> select get_rowid('AAATMDAAEAAAAo2AAB') from test;

GET_ROWID('AAATMDAAEAAAAO2AAB')
--------------------------------------------------------------------------------
Object# is      :78595
Relative_fno is :4
Block number is :2614
Row number is   :1

Object# is      :78595
Relative_fno is :4
Block number is :2614
Row number is   :1

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15881763/viewspace-690373/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15881763/viewspace-690373/