Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 136 of 177
to_clob::=
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 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);
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|