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
Related Commands:
Related Packages: