Syntax
Purpose
ROWIDTOCHAR converts a rowid value toVARCHAR2 data type. The result of this conversion is always 18 characters long.
See Also:
Appendix C inOracle Database Globalization Support Guide for the collation derivation rules, which define the collation assigned to the character return value ofROWIDTOCHAR
Examples
The following example converts a rowid value in theemployees 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