Oracle PL/SQL Tutorial/Conversion Functions/ROWIDTOCHAR

ROWIDTOCHAR(x): Converts the ROWID x to a VARCHAR2 character.

   <source lang="sql">

SQL> SQL> SELECT ROWID FROM employee WHERE ROWIDTOCHAR(ROWID) LIKE "%F38%"

 2</source>