Return to Snippet

Revision: 71589
at March 2, 2017 10:43 by bbrumm


Initial Code
--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;

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

Initial Description
A few examples of the TO_NCLOB function.

Initial Title
Oracle TO_NCLOB Function

Initial Tags
sql, Oracle

Initial Language
SQL