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






DBMS_ROWID.ROWID_RELATIVE_FNO(RowID)

 


SQL> select DBMS_ROWID.ROWID_RELATIVE_FNO(RowID)
  2    from dual
  3   where RowNum=1;
                                                              

DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID)
------------------------------------
                                   1

   
  








Related examples in the same category

1.DBMS_ROWID.ROWID_BLOCK_NUMBER(RowID)
2.DBMS_ROWID.ROWID_RELATIVE_FNO(RowID),DBMS_ROWID.ROWID_BLOCK_NUMBER(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