Oracle® Database SQL Language Reference 11g Release 1 (11.1) Part Number B28286-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%' ORDER BY ROWID; ROWID ------------------ AAAFfIAAFAAAABSAAb