Oracle PL/SQL: TO NCLOB - Converts CLOB values in a LOB column or other character strings to NCLOB values. char can be any of

Quick Search:

Oracle PL/SQL: TO_NCLOB

Jump to:

Category: >> Oracle PL/SQL >> TO_NCLOB

<< last

next >>

Snippet Name: TO_NCLOB

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.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» UNISTR
» TRANSLATE
» TO_YMINTERVAL
» TO_TIMESTAMP_TZ
» TO_TIMESTAMP
» TO_SINGLE_BYTE
» TO_NUMBER
» TO_NCHAR
» TO_MULTI_BYTE
» TO_LOB
» TO_DSINTERVAL
» TO_DATE
» TO_CLOB
» TO_CHAR
» TO_BINARY_FLOAT
» TO_BINARY_DOUBLE
» TIMESTAMP_TO_SCN
» SCN_TO_TIMESTAMP
» ROWIDTONCHAR
» ROWIDTOCHAR
» REFTOHEX
» RAWTONHEX
» RAWTOHEX
» NUMTOYMINTERVAL
» NUMTODSINTERVAL
» HEXTORAW
» DECOMPOSE
» CONVERT

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

TO_NCLOB(lob_column | CHAR string)
 
 
INSERT INTO print_media (product_id, ad_id, ad_fltextn)
   VALUES (3502, 31001, 
      TO_NCLOB('Placeholder for new product description'));
 
 
 
CREATE TABLE nclob_dummy(
nclobcol  NCLOB);
 
INSERT INTO nclob_dummy
(nclobcol)
VALUES
(TO_NCLOB('This text will be converted into the NCLOB datatype'));