DBMS_ROWID.ROWID_RELATIVE_FNO(RowID),DBMS_ROWID.ROWID_BLOCK_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_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








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)