PL/SQL Packages DBMS_ROWID

Create ROWIDs and obtain information about ROWIDs from PL/SQL programs and SQL statements.

Subprocedures:

ROWID_CREATE Function
              Create a ROWID, for testing only. 

ROWID_INFO    Returns the type and components of a ROWID. 

ROWID_TYPE Function
              Returns the ROWID type: 0 is restricted, 1 is extended. 

ROWID_OBJECT Function
              Returns the object number of the extended ROWID. 

ROWID_RELATIVE_FNO Function
              Returns the file number of a ROWID. 

ROWID_BLOCK_NUMBER Function
              Returns the block number of a ROWID. 

ROWID_ROW_NUMBER Function
              Returns the row number. 

ROWID_TO_ABSOLUTE_FNO Function
              Returns the absolute file number associated with the
              ROWID for a row in a specific table. 

ROWID_TO_EXTENDED Function
              Convert a ROWID from restricted format to extended. 

ROWID_TO_RESTRICTED Function
              Convert an extended ROWID to restricted format. 

ROWID_VERIFY Function
              Check if a ROWID can be correctly extended by the
              ROWID_TO_EXTENDED function.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Nothing is permanent. - Buddha


 
Copyright © 1999-2024 SS64.com
Some rights reserved