Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle TO_CLOB Function       [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: TO_CLOB

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...
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 71 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?