Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / 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