Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
Purpose
ROWIDTOCHAR
converts a rowid value to VARCHAR2
datatype. The result of this conversion is always 18 characters long.
Examples
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%'; ROWID ------------------ AAAFfIAAFAAAABSAAb