Oracle/PLSQL: To_Clob Function

In Oracle/PLSQL, the to_clob function converts a LOB value from the national character set to the database character set.

The syntax for the to_clob function is:

to_clob( expression )

expression can either be a lob_column, char, varchar2, nchar, nvarchar2, clob or nclob value.

Applies To:

For example:

select to_clob(nclob_column)
from suppliers;

This example would convert the value in the field called nclob_column to a CLOB value.