DBMS_ROWID can be used to convert ROWIDs into a
Procedures/Functions
rowid_block_number
function rowid_block_number returns number (
row_id in rowid ,
ts_type_in in varchar2 default
);
rowid_create
function rowid_create returns rowid (
rowid_type in number ,
object_number in number ,
relative_fno in number ,
block_number in number ,
row_number in number
);
rowid_info
procedure rowid_info (
rowid_in in rowid ,
rowid_type out number ,
object_number out number ,
relative_fno out number ,
block_number out number ,
row_number out number ,
ts_type_in in varchar2 default
);
rowid_object
function rowid_object returns number (
row_id in rowid
);
rowid_relative_fno
function rowid_relative_fno returns number (
row_id in rowid ,
ts_type_in in varchar2 default
);
rowid_row_number
function rowid_row_number returns number (
row_id in rowid
);
rowid_to_absolute_fno
function rowid_to_absolute_fno returns number (
row_id in rowid ,
schema_name in varchar2 ,
object_name in varchar2
);
rowid_to_extended
function rowid_to_extended returns rowid (
old_rowid in rowid ,
schema_name in varchar2 ,
object_name in varchar2 ,
conversion_type in number(38)
);
rowid_to_restricted
function rowid_to_restricted returns rowid (
old_rowid in rowid ,
conversion_type in number(38)
);
rowid_type
function rowid_type returns number (
row_id in rowid
);
rowid_verify
function rowid_verify returns number (
rowid_in in rowid ,
schema_name in varchar2 ,
object_name in varchar2 ,
conversion_type in number(38)
);
|