Java bro

Java tutorial

Sql queries

Convert Long values to LOB values in sql

In this tutorial we are going to convert LONG values to LOB values using TO_LOB function. See the below example.

Syntax:

SELECT TO_LOB(long_column_name) FROM table_name;

We can convert LONG and LONG RAW values to LOB using TO_LOB function .

Comments are Closed

Theme by Anders Norén