TO_NCLOB Function in Oracle SQL – PLSQL

The TO_NCLOB function in Oracle SQL / PLSQL is used to convert a LOB value to NCLOB value.

Syntax for the TO_NCLOB function in Oracle SQL / PLSQL is:

SELECT TO_NCLOB(expression_1)
FROM table_name;

expression_1 can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB

Examples:

SELECT TO_NCLOB(employee_name)
FROM employee;

Tagged , , , , , , , , , , , . Bookmark the permalink.