Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 103 of 166
rowidtochar::=
rowidtochar
ROWIDTOCHAR
converts a rowid value to VARCHAR2
datatype. The result of this conversion is always 18 characters long.
The following example converts a rowid value in the employees
table to a character value:
SELECT ROWID FROM employees WHERE ROWIDTOCHAR(ROWID) LIKE '%JAAB%'; ROWID ------------------ AAABIQAAEAAAAEJAAB
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|