Oracle TO_CLOB Function - SQL Snipplr Social Repository

Revision: 71588

at March 2, 2017 10:42 by bbrumm

Initial Code

--TO_CLOB

--Example 1
SELECT first_name, TO_CLOB(first_name) AS clob_value
FROM student
WHERE student_id = 1;

--Example 2
CREATE TABLE datatype_test (
nclob_column NCLOB
);

INSERT INTO datatype_test (nclob_column)
VALUES ('This is Ã¤ tÃ«st');

SELECT nclob_column, TO_CLOB(nclob_column) AS clobvalue
FROM datatype_test;

Initial URL

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

Initial Description

A few examples of the TO_CLOB function.

Initial Title

Oracle TO_CLOB Function

Initial Tags

sql, Oracle

Initial Language

SQL

Choose a language for easy browsing: