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