Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

DBMS_ROWID ROWID_RELATIVE_FNO(RowID),DBMS_ROWID ROWID_BLOCK_NUMBER(RowID)

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