TO_CLOB

TO_CLOB is a SQL function used to convert a LOB value from the NCLOB data type to CLOB data type or a LONG value to a CLOB value. It's primarily used when the input data type might not be compatible with operations or functions that are designed for use with the CLOB data type.

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.