René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_rowid

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)        
);