Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
ROWIDTONCHAR
converts a rowid value to NVARCHAR2
datatype. The result of this conversion is always 18 characters long.
The following example converts a rowid value to an NVARCHAR2
string:
SELECT LENGTHB( ROWIDTONCHAR(ROWID) ), ROWIDTONCHAR(ROWID) FROM employees; LENGTHB(ROWIDTONCHAR(ROWID)) ROWIDTONCHAR(ROWID ---------------------------- ------------------ 36 AAAFfIAAFAAAABSAAA . . .