ROWIDTOCHAR
converts a rowid value to VARCHAR2
data type. The result of this conversion is always 18 characters long.
The following example converts a rowid value in the employees
table to a character value. (Results vary for each build of the sample database.)
SELECT ROWID FROM employees WHERE ROWIDTOCHAR(ROWID) LIKE '%JAAB%' ORDER BY ROWID; ROWID ------------------ AAAFfIAAFAAAABSAAb