|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 136 of 177
NCLOB values in a LOB column or other character strings to
char can be any of the datatypes
NCLOB. Oracle executes this function by converting the underlying LOB data from the national character set to the database character set.
The following statement converts
NCLOB data from the sample
pm.print_media table to
CLOB and inserts it into a
CLOB column, replacing existing data in that column.