DBMS_ROWID.ROWID_TO_RESTRICTED(RowID,0) : dbms_rowid « System Packages « Oracle PL / SQL






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

DBMS_ROWID.ROWID_TO_RESTRICTED(RowID,0)

 
SQL> select DBMS_ROWID.ROWID_TO_RESTRICTED(RowID,0)
  2    from dual;
                                                              

DBMS_ROWID.ROWID_T
------------------
00000822.0000.0001








Related examples in the same category

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