Posted By

bbrumm on 03/02/17


Tagged

sql Oracle


Versions (?)

Oracle TO_CLOB Function


 / Published in: SQL
 

URL: http://www.databasestar.com/oracle-to_clob/

A few examples of the TO_CLOB function.

  1. --TO_CLOB
  2.  
  3. --Example 1
  4. SELECT first_name, TO_CLOB(first_name) AS clob_value
  5. FROM student
  6. WHERE student_id = 1;
  7.  
  8. --Example 2
  9. CREATE TABLE datatype_test (
  10. nclob_column NCLOB
  11. );
  12.  
  13. INSERT INTO datatype_test (nclob_column)
  14. VALUES ('This is ä tëst');
  15.  
  16. SELECT nclob_column, TO_CLOB(nclob_column) AS clobvalue
  17. FROM datatype_test;

Report this snippet  

You need to login to post a comment.