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>
<source lang="sql">
SQL> SQL> SELECT ROWID FROM employee WHERE ROWIDTOCHAR(ROWID) LIKE "%F38%"
2</source>