Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

DBMS_ROWID ROWID_BLOCK_NUMBER(RowID)

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