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.