Java bro

Java tutorial

Sql queries

Convert NCLOB vlaues to CLOB ins sql

In this tutorial we are going to convert NCLOB (National character set) to CLOB (Database character set) using TO_CLOB function. See the below example.

Syntax:

SELECT TO_CLOB(nclob_column) FROM table_name;

We can paas char, varchar2, nchar, nvarchar2, clob , nclob values to TO_CLOB function .

Comments are Closed

Theme by Anders Norén