To_clob – Oracle SQL Function

TO_CLOB converts character data to a CLOB.

The string argument can be a CHAR, VARCHAR2, NCHAR NVARCHAR2, CLOB, or NCLOB data type.

Example:

SELECT TO_CLOB(‘SOME DATA’) as RESULT from DUAL;

RESULT
————
SOME DATA