Oracle PL/SQL Tutorial/Conversion Functions/ROWIDTOCHAR
ROWIDTOCHAR(x): Converts the ROWID x to a VARCHAR2 character.
SQL>
SQL> SELECT ROWID FROM employee WHERE ROWIDTOCHAR(ROWID) LIKE "%F38%"
2
SQL>
SQL> SELECT ROWID FROM employee WHERE ROWIDTOCHAR(ROWID) LIKE "%F38%"
2