Quick Search:
 The Oracle TO_CLOB Function       [Return To Index] Jump to:  


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...
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org