Coder Tutorial

PL/SQL To_Lob

Oracle PL/SQL To_Lob Function

The To_Lob function converts LONG or LONG RAW values to LOB values.

The To_Lob Function syntax:

to_lob( long_column )

Example

insert into customers (lob_column)
select to_lob(long_column)
from suppliers;