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 SS64.com 1999-2013
Some rights reserved