Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 133 of 166
to_clob::=
to_clob
The TO_CLOB
function 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.
UPDATE PRINT_MEDIA SET AD_FINALTEXT = TO_CLOB (AD_FLTEXTN);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|