Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
ISBN: 0596514468
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 234
Pages: 234
Authors: Steven Feuerstein, Bill Pribyl
| Appendix C Built-In Packages |
Use the DBMS_ROWID package to work with ROWIDs from within PL/SQL programs and SQL statements. Remember that as of Oracle8, there are two types of ROWIDs: extended and restricted. Restricted ROWIDs are the ROWIDs available with Oracle Version 7 and earlier. Extended ROWIDs are used in Oracle8.
Call the create function to create a ROWID (either restricted or extended as you request) based on the individual ROWID component values you specify. This should be used for test purposes only. The specification is:
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;
The info procedure returns information about the specified ROWID. This procedure essentially "parses" the ROWID. The specification is:
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);
The type function determines if the ROWID is restricted or extended. It returns if the ROWID is restricted, and 1 if the ROWID is extended. The specification is:
FUNCTION DBMS_ROWID.ROWID_TYPE (row_id IN ROWID) RETURN NUMBER;
Use the object function to return the data object number for an extended ROWID. The object function returns if the specified ROWID is restricted. The specification is:
FUNCTION DBMS_ROWID.ROWID_OBJECT (row_id IN ROWID) RETURN NUMBER;
The relative_fno function returns the relative file number (relative to the tablespace) of the ROWID. The specification is:
FUNCTION DBMS_ROWID.ROWID_RELATIVE_FNO (row_id IN ROWID) RETURN NUMBER;
Use the block_number function to return the database block number of the ROWID. The specification is:
FUNCTION DBMS_ROWID.ROWID_BLOCK_NUMBER (row_id IN ROWID) RETURN NUMBER;
The row_number function returns the row number of the ROWID. The specification is:
FUNCTION DBMS_ROWID.ROWID_ROW_NUMBER (row_id IN ROWID) RETURN NUMBER;
Call the to_absolute_fno function to return the absolute file number (for a row in a given schema and table) from the ROWID. The specification is:
FUNCTION DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO (row_id IN ROWID, schema_name IN VARCHAR2, object_name IN VARCHAR2) RETURN NUMBER;
The to_extended function converts a restricted ROWID to an extended ROWID. The specification is:
FUNCTION DBMS_ROWID.ROWID_TO_EXTENDED (old_rowid IN ROWID, schema_name IN VARCHAR2, object_name IN VARCHAR2, conversion_type IN INTEGER) RETURN ROWID;
The to_restricted function converts an extended ROWID to a restricted ROWID. The specification is:
FUNCTION DBMS_ROWID.ROWID_TO_RESTRICTED (old_rowid IN ROWID, conversion_type IN INTEGER) RETURN ROWID;
Use the verify function to determine whether a restricted ROWID can be converted to an extended format. The verify function returns if the ROWID provided can be converted and 1 otherwise. The specification is:
FUNCTION DBMS_ROWID.ROWID_VERIFY (rowid_in IN ROWID, schema_name IN VARCHAR2, object_name IN VARCHAR2, conversion_type IN INTEGER) RETURN NUMBER;
| C.10 DBMS_PIPE | C.12 DBMS_SESSION |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.