Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
Purpose
TO_CLOB
converts NCLOB
values in a LOB column or other character strings to CLOB
values. char
can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, NVARCHAR2
, CLOB
, or NCLOB
. Oracle Database executes this function by converting the underlying LOB data from the national character set to the database character set.
Examples
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);