Oracle/PLSQL: To_NClob Function

In Oracle/PLSQL, the to_nclob function converts a LOB value to a NCLOB value.

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:

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.