DBMS_ROWID.ROWID_ROW_NUMBER(RowID) : dbms_rowid « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_rowid
SQL> select DBMS_ROWID.ROWID_ROW_NUMBER(RowID)
  2    from dual;
                                                              

DBMS_ROWID.ROWID_ROW_NUMBER(ROWID)
----------------------------------
                                 0
SQL>
SQL>








31.23.dbms_rowid
31.23.1.Use dbms_rowid.rowid_block_number
31.23.2.DBMS_ROWID.ROWID_TO_RESTRICTED
31.23.3.DBMS_ROWID.ROWID_BLOCK_NUMBER and DBMS_ROWID.ROWID_ROW_NUMBER
31.23.4.Max # Rows/Block
31.23.5.Min # Rows/BLock
31.23.6.Avg # Rows/Block
31.23.7.Distinct Blocks
31.23.8.DBMS_ROWID.ROWID_RELATIVE_FNO(RowID)
31.23.9.DBMS_ROWID.ROWID_RELATIVE_FNO(RowID),DBMS_ROWID.ROWID_BLOCK_NUMBER(RowID)
31.23.10.DBMS_ROWID.ROWID_ROW_NUMBER(RowID)
31.23.11.DBMS_ROWID.ROWID_TO_RESTRICTED(RowID,0)