ROWIDTOCHAR(x): Converts the ROWID x to a VARCHAR2 character. : ROWIDTOCHAR « Conversion Functions « Oracle PL/SQL Tutorial






SQL>
SQL> SELECT ROWID FROM employee WHERE ROWIDTOCHAR(ROWID) LIKE '%F38%'
  2
15.5.ROWIDTOCHAR
15.5.1.ROWIDTOCHAR(x): Converts the ROWID x to a VARCHAR2 character.