NCLOB values in a LOB column or other character strings to
char can be any of the datatypes
NCLOB. Oracle Database 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.
UPDATE PRINT_MEDIA SET AD_FINALTEXT = TO_CLOB (AD_FLTEXTN);