TO_NCLOB function in oracle to convert a LOB value to NCLOB value.

By Santhosh N

This explains how to convert LOB value to NCLOB value in oracle.

There is a conversion function in oracle by the name, TO_NCLOB which converts the LOB value to NCLOB value.

Syntax: TO_NCLOB(str)

Here str is any of either char, varchar2, nchar, nvarchar2, clob or nclob value.

Related FAQs

TO_CLOB function in oracle to convert a LOB value from the national set to the Database character set.
This explains how to convert LOB value from the national character set to the Database character set.
TO_LOB function in oracle to convert LONG or LONG RAW values to LOB values.
This explains how to convert LONG or LONG RAW values to LOB values.
HEXTORAW function in oracle to convert hexadecimal value into a raw value.
This explains how to convert a hexadecimal value into a raw value in oracle.
Convert single-byte and multi-byte characters In Oracle using TO_MULTI_BYTE
This explains how to convert the both single-byte and multi-byte characters in oracle string to multi-byte characters.
TO_TIMESTAMP_TZ function in oracle to convert a string to timestamp with time zone value.
This explains how to convert a string value to the timestamp with time zone value in oracle.
TO_TIMESTAMP function in oracle to convert a string to timestamp value.
This explains how to convert a string value to the timestamp value in oracle.
TO_NCLOB function in oracle to convert a LOB value to NCLOB value.  (1374 Views)