Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 104 of 166
rowidtonchar::=
rowidtonchar
The ROWIDTONCHAR
function converts a rowid value to NVARCHAR2
datatype. The result of this conversion is always 18 characters long.
SELECT LENGTHB( ROWIDTONCHAR(ROWID) ), ROWIDTONCHAR(ROWID) FROM emp; LENGTHB(ROWIDTONCHAR(ROWID)) ROWIDTONCHAR(ROWID) ---------------------------- ------------------------------------ 36 AAAHymAABAAASuWAAA
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|