TO_NCLOB 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 Database implements this function by converting the character set of char from the database character set to the national character set.
The syntax for the to_nclob function is:
to_nclob( expression )
expression can be a char, varchar2, nchar, nvarchar2, clob or nclob value.
Applies To:
· Oracle 9i, Oracle 10g, Oracle 11g
For example:
select to_nclob(lob_column)
from suppliers;
This example would convert the value in the field called lob_column to an NCLOB value.
