Oracle / PLSQL: TO_NCLOB Function

This article is written about how to use the Oracle/PLSQL TO_NCLOB function with syntax and examples.


The Oracle/PLSQL TO_NCLOB characteristic converts a LOB value to a NCLOB value.


The syntax for the TO_NCLOB function in Oracle/PLSQL is:

TO_NCLOB( expression )

Parameters or Arguments

expression A char, varchar2, nchar, nvarchar2, clob or nclob value that will be converted to a NCLOB value.


The TO_NCLOB function returns a NCLOB value.

Applies To

The TO_NCLOB characteristic can be used in the following variations of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i


Let’s seem at some Oracle TO_NCLOB feature examples and discover how to use the TO_NCLOB function in Oracle/PLSQL.

For example:

select TO_NCLOB(lob_column)
from suppliers;

This instance would convert the value in the field known as lob_column to an NCLOB value.