ROWID_RELATIVE_FNO Function

This function returns the relative file number of the ROWID specified as the IN parameter. (The file number is relative to the tablespace.)

Syntax

DBMS_ROWID.ROWID_RELATIVE_FNO (
   rowid_id IN ROWID)
  RETURN NUMBER;

Pragmas

   pragma RESTRICT_REFERENCES(rowid_relative_fno,WNDS,RNDS,WNPS,RNPS);

Parameters

Table 57-6 ROWID_RELATIVE_FNO Function Parameters

Parameter	Description
row_id	ROWID to be interpreted.

Example

The example PL/SQL code fragment returns the relative file number:

DECLARE

file_number    INTEGER;
rowid_val      ROWID;

BEGIN

SELECT ROWID INTO rowid_val
  FROM dept 
  WHERE loc = 'Boston';
file_number :=
  dbms_rowid.rowid_relative_fno(rowid_val);
...