In Oracle/PLSQL, the to_clob function converts a LOB value from the national character set to the database character set.
Syntax
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
- Oracle 11g, Oracle 10g, Oracle 9i
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.