Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 141 of 166
to_nclob::=
to_nclob
The TO_NCLOB
function converts CLOB
values in a LOB column or other character strings to NCLOB
values. char
can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, NVARCHAR2
, CLOB
, or NCLOB
. Oracle implements this function by converting the character set of the LOB column from the database character set to the national character set.
The following example inserts some character data into an NCLOB column of the pm.print_media table by first converting the data with the TO_NCLOB function:
INSERT INTO print_media (product_id, ad_id, ad_fltextn) VALUES (3502, 31001, TO_NCLOB('Placeholder for new product description'));
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|