Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_ROWID , 9 of 12
This function extracts the absolute file number from a ROWID
, where the file number is absolute for a row in a given schema and table. The schema name and the name of the schema object (such as a table name) are provided as IN
parameters for this function.
DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO ( row_id IN ROWID, schema_name IN VARCHAR2, object_name IN VARCHAR2) RETURN NUMBER;
pragma RESTRICT_REFERENCES(rowid_to_absolute_fno,WNDS,WNPS,RNPS);
Parameter | Description |
---|---|
row_id |
|
schema_name |
Name of the schema which contains the table. |
object_name |
Table name. |
DECLAREabs_fno INTEGER; rowid_val CHAR(18); object_name VARCHAR2(20) := 'EMP';BEGINSELECT ROWID INTO rowid_val FROM emp WHERE empno = 9999; abs_fno := dbms_rowid.rowid_to_absolute_fno( rowid_val, 'SCOTT', object_name);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|