Skip to content
Java bro

Java full stack tutorial

  • Home
  • Java
    • Core java
    • Advance java
    • Java examples
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Struts 1.x
    • Struts 2.x
    • Hibernate
    • TypeScript
    • Angular
    • ReactJs
  • Spring
    • Spring core
    • Spring DAO
    • Spring ORM
    • Spring AOP
    • Spring MVC
    • Spring Boot
  • Micro services
    • Zuul
    • Cloud config server
    • Hystrix
    • Kafka
    • Redis cache
    • Sleuth
    • Zipkins
  • Interview Q&A
    • Java
    • Jdbc
    • Servlets
    • Jsp
    • Struts
    • Hibernate
    • Spring
    • Micro services
    • Angular
    • React Js
  • Others
    • Servers
    • IDEs
    • Java practice
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge
Java bro

Java full stack tutorial

  • Home
  • Java
    • Core java
    • Advance java
    • Java examples
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Struts 1.x
    • Struts 2.x
    • Hibernate
    • TypeScript
    • Angular
    • ReactJs
  • Spring
    • Spring core
    • Spring DAO
    • Spring ORM
    • Spring AOP
    • Spring MVC
    • Spring Boot
  • Micro services
    • Zuul
    • Cloud config server
    • Hystrix
    • Kafka
    • Redis cache
    • Sleuth
    • Zipkins
  • Interview Q&A
    • Java
    • Jdbc
    • Servlets
    • Jsp
    • Struts
    • Hibernate
    • Spring
    • Micro services
    • Angular
    • React Js
  • Others
    • Servers
    • IDEs
    • Java practice
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge
  • Home
  • Java
    • Core java
    • Advance java
    • Java examples
  • J2ee
    • Jdbc
    • Servlets
    • Jsp
    • Jstl
  • Frame works
    • Struts 1.x
    • Struts 2.x
    • Hibernate
    • TypeScript
    • Angular
    • ReactJs
  • Spring
    • Spring core
    • Spring DAO
    • Spring ORM
    • Spring AOP
    • Spring MVC
    • Spring Boot
  • Micro services
    • Zuul
    • Cloud config server
    • Hystrix
    • Kafka
    • Redis cache
    • Sleuth
    • Zipkins
  • Interview Q&A
    • Java
    • Jdbc
    • Servlets
    • Jsp
    • Struts
    • Hibernate
    • Spring
    • Micro services
    • Angular
    • React Js
  • Others
    • Servers
    • IDEs
    • Java practice
    • Realtime exceptions
    • Sql Tutorial
    • Sql Queries
    • Domain knowledge

Convert NCLOB vlaues to CLOB ins sql

  • Home
  • Sql queries
  • Convert NCLOB vlaues to CLOB ins sql
  • Sql queries
  • vsreenu48
  • May 2, 2020November 23, 2020
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 .
Prev post Convert Long values to LOB values in sql
Next post Type 'Promise<string[]>' is not assignable to type 'string[]'

Recent Posts

  • PKIX path building failed and unable to find valid certification path to requested target in MAC Os
  • No router instance found. You should only use “next/router” inside the client side of your app
  • TypeError: First argument must be a string in React
  • Create a thread by implementing Runnable interface
  • Create a thread by extending Thread class
  • Life cycle of a thread
  • Introduction to multi threading in java
  • List Interface in java

Popular posts

  • JBAS011232: Only one JAX-RS Application Class allowed 607 views
  • Type ‘Promise‘ is not assignable to type ‘string[]’ 300 views
  • Convert NCLOB vlaues to CLOB ins sql 300 views
  • Convert Long values to LOB values in sql 200 views
  • Get today date in sql 200 views
  • Get last date of month in sql 200 views
  • Should not consume any form parameter 101 views
  • jspService is exceeding the 65535 bytes limit 101 views

Views

6120

Orchid Store Theme by Themebeez