Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

DBMS_ROWID ROWID_RELATIVE_FNO(RowID)

SQL> select DBMS_ROWID.ROWID_RELATIVE_FNO(RowID)   2    from dual   3   where RowNum=1;                                                                DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) ------------------------------------                                    1