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






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. ROWIDTOCHAR
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.