oracle to_clob

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