Posted By

bbrumm on 03/02/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/02/17 10:43am

Statistics

Viewed 1026 times

Favorited by 0 user(s)

Related snippets

Oracle TO_NCLOB Function

/ Published in: SQL

A few examples of the TO_NCLOB function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--TO_NCLOB
 
--Example 1
SELECT first_name,
TO_NCLOB(first_name) AS nclob_value
FROM student
WHERE student_id = 1;
 
--Example 2
CREATE TABLE datatype_test (
clob_column CLOB
);
 
INSERT INTO datatype_test (nclob_column)
VALUES ('This is Ã¤ tÃ«st');
 
SELECT nclob_column, TO_NCLOB(nclob_column) AS nclobvalue
FROM datatype_test;