Oracle/PLSQL: To_Lob Function

In Oracle/PLSQL, the to_lob function converts LONG or LONG RAW values to LOB values.

Syntax

The syntax for the to_lob function is:

to_lob( long_column )

long_column can be a LONG or LONG RAW value.

Applies To

• Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

For Example

insert into companies (lob_column)

select to_lob(long_column)

from suppliers;

This example would convert the value in the field called long_column to a LOB value.