declare
ridtyp number;
objnum number;
relfno number;
blno number;
rowno number;
rid rowid;
begin
select rowid into rid from test where id=1;
dbms_rowid.rowid_info(rid, ridtyp,objnum,relfno,blno,rowno );
dbms_output.put_line('Row Type:' || to_char(ridtyp));
dbms_output.put_line('objnum:' || to_char(objnum));
dbms_output.put_line('relfno:' || to_char(relfno));
ridtyp number;
objnum number;
relfno number;
blno number;
rowno number;
rid rowid;
begin
select rowid into rid from test where id=1;
dbms_rowid.rowid_info(rid, ridtyp,objnum,relfno,blno,rowno );
dbms_output.put_line('Row Type:' || to_char(ridtyp));
dbms_output.put_line('objnum:' || to_char(objnum));
dbms_output.put_line('relfno:' || to_char(relfno));
dbms_output.put_line('blno:' || to_char(blno));
dbms_output.put_line('rowno :' || to_char(rowno ));
end;
dbms_output.put_line('rowno :' || to_char(rowno ));
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-773536/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27042095/viewspace-773536/