TO_CLOB

Oracle

TO_CLOB(character_value)

• character_value: A VARCHAR2 value that will be converted to a CLOB. This argument comes in the form of a string and represents the data to be converted to the CLOB data type.

Example

SELECT TO_CLOB('Oracle Conversion') FROM dual;

Output

TO_CLOB('Oracle Conversion')
---------------------------
Oracle Conversion

Explanation

The TO_CLOB function converts a NCLOB, BLOB, BFILE, BINARY_FLOAT, BINARY_DOUBLE, or a user-defined type column to a CLOB column. In the given example, the string ‘Oracle Conversion’ is converted to a CLOB.