Oracle in a Nutshell

Calls

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,