December 2002
Intermediate to advanced
928 pages
85h 29m
English
FUNCTION DBMS_ROWID.ROWID_BLOCK_NUMBER
(row_id IN ROWID)
RETURN NUMBER;
Returns the block number component of row_id.
FUNCTION DBMS_ROWID.ROWID_CREATE
(rowid_type IN NUMBER,
object_number IN NUMBER,
relative_fno IN NUMBER,
block_number IN NUMBER,
row_number IN NUMBER)
RETURN ROWID;
Creates a rowid_type ROWID composed of object_number, relative_fno, block_number, and row_number. rowid_type can be ROWID_TYPE_EXTENDED or ROWID_TYPE_ RESTRICTED. object_number can be ROWID_OBJECT_UNDEFINED or the object number (OID).
PROCEDURE DBMS_ROWID.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);
Parses rowid_in into its individual components. rowid_type can be ROWID_TYPE_EXTENDED or ROWID_TYPE_RESTRICTED. object_number can be ROWID_OBJECT_UNDEFINED or the object number (OID).
FUNCTION DBMS_ROWID.ROWID_OBJECT
(row_id IN ROWID)
RETURN NUMBER;
Returns the object number component of row_id.
FUNCTION DBMS_ROWID.ROWID_RELATIVE_FNO
(row_id IN ROWID)
RETURN NUMBER;
Returns the relative file number component of row_id.
FUNCTION DBMS_ROWID.ROWID_ROW_NUMBER
(row_id IN ROWID)
RETURN NUMBER;
Returns the row number component of row_id.
FUNCTION DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO
(row_id IN ROWID,
schema_name IN VARCHAR2,
object_name IN VARCHAR2)
RETURN NUMBER;
Returns the absolute file number for row_id, schema_name, and object_name.
FUNCTION DBMS_ROWID.ROWID_TO_EXTENDED
(old_rowid IN ROWID,