Description: 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.
The database implements this function by converting the character set of char from the database character set to the national character set.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
TO_NCLOB(lob_column | CHAR string)INSERTINTO print_media (product_id, ad_id, ad_fltextn)VALUES(3502,31001,TO_NCLOB('Placeholder for new product description'));CREATETABLE nclob_dummy(
nclobcol NCLOB);INSERTINTO nclob_dummy
(nclobcol)VALUES(TO_NCLOB('This text will be converted into the NCLOB datatype'));
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.
