Posted By

bbrumm on 03/02/17


Tagged

sql Oracle


Versions (?)

Oracle TO_NCLOB Function


 / Published in: SQL
 

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

A few examples of the TO_NCLOB function.

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

Report this snippet  

You need to login to post a comment.