Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 130 of 166
to_char_char::=
to_char_char
The TO_CHAR
(character) function converts NCHAR
, NVARCHAR2
, CLOB
, or NCLOB
data to the database character set.
The following example converts some CLOB
data from the pm.print_media
table to the database character set:
SELECT TO_CHAR(ad_sourcetext) FROM print_media WHERE product_id = 2268; TO_CHAR(AD_SOURCETEXT) -------------------------------------------------------------------- ****************************** TIGER2 2268...Standard Hayes Compatible Modem Product ID: 2268 The #1 selling modem in the universe! Tiger2's modem includes call management and Internet voicing. Make real-time full duplex phone calls at the same time you're online. **********************************
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|