• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / TO_NCLOB Function in Oracle SQL – PLSQL

TO_NCLOB Function in Oracle SQL – PLSQL

November 27, 2012 by techhoneyadmin

The TO_NCLOB function in Oracle SQL / PLSQL is used to convert a LOB value to NCLOB value.

Syntax for the TO_NCLOB function in Oracle SQL / PLSQL is:

SELECT TO_NCLOB(expression_1)
FROM table_name;

expression_1 can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB

Examples:

SELECT TO_NCLOB(employee_name)
FROM employee;

Filed Under: function Tagged With: how to use TO_NCLOB function in oracle database query, how to use TO_NCLOB function in oracle plsql, how to use TO_NCLOB function in oracle sql, syntax and example of TO_NCLOB function in oracle database query, syntax and example of TO_NCLOB function in oracle plsql, syntax and example of TO_NCLOB function in oracle sql, TONCLOBPLSQL, TO_NCLOB function in oracle plsql, TO_NCLOB function in oracle sql, using TO_NCLOB function in oracle database query, using TO_NCLOB function in oracle plsql, using TO_NCLOB function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in