Definition:
The Oracle TO_CLOB function converts NCLOB values a character string (or in a LOB column) to CLOB values. The character strings can be of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.
The Oracle Database processes this function by converting the underlying LOB data from the current national character set to the database character set.
Example Syntax:
UPDATE user_table
SET country_zone = TO_CLOB (country_text);
Related Links:
Related Code Snippets:
- TO_CLOB - The TO_CLOB function converts NCLOB values in a LOB column or other character strings to...
