TO_LOB
Syntax
Purpose
TO_LOB converts LONG or LONG RAW values in the column long_column to LOB
values. You can apply this function only to a LONG or LONG RAW column, and only
in the SELECT list of a subquery in an INSERT statement.
Before using this function, you must create a LOB column to receive the converted
LONG values. To convert LONGs, create a CLOB column. To convert LONG RAWs,
create a BLOB column.
Example
Given the following tables:
CREATE TABLE long_table (n NUMBER, long_col LONG);
CREATE TABLE lob_table (n NUMBER, lob_col CLOB);
use this function to convert LONG to LOB values as follows:
See Also: INSERT on page  11 - 51  for information on the subquery
of an INSERT statement
TO_LOB ( long_column )

INSERT INTO lob_table
SELECT n, TO_LOB(long_col) FROM long_table;