DBMS_ROWID.ROWID_RELATIVE_FNO(RowID),DBMS_ROWID.ROWID_BLOCK_NUMBER(RowID) : dbms_rowid « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_rowid

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








Related examples in the same category

1.DBMS_ROWID.ROWID_BLOCK_NUMBER(RowID)
2.DBMS_ROWID.ROWID_RELATIVE_FNO(RowID)
3.DBMS_ROWID.ROWID_ROW_NUMBER(RowID)
4.DBMS_ROWID.ROWID_TO_RESTRICTED(RowID,0)
5.where rowid = dbms_rowid.rowid_create(1,49627,7,138,0)
6.dbms_rowid.rowid_block_number(rowid) and ora_rowscn