TO_CHAR (character)

Syntax

to_char_char::=

Text description of to_char_char

Purpose

The TO_CHAR (character) function converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the database character set.

Example

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.

**********************************