Oracle/PLSQL: To_Lob Function

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

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 8i, Oracle 9i, Oracle 10g, Oracle 11g

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.