Oracle / PLSQL: TO_LOB Function

This article is written about how to use the Oracle/PLSQL TO_LOB function with syntax and examples.


The Oracle/PLSQL TO_LOB characteristic converts LONG or LONG RAW values to LOB values.


The syntax for the TO_LOB function in Oracle/PLSQL is:

TO_LOB( long_column )

Parameters or Arguments

long_column A LONG or LONG RAW fee that will be converted to a LOB.


The TO_LOB function returns a LOB value.

Applies To

The TO_LOB feature can be used in the following versions of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i


Let’s seem at some Oracle TO_LOB characteristic examples and discover how to use the TO_LOB characteristic in Oracle/PLSQL.

For example:

insert into companies (lob_column)
select TO_LOB(long_column)
from suppliers;

This instance would convert the price in the discipline known as long_column to a LOB value.