CREATE TABLE first_table (
id NUMBER,
longval LONG
);

INSERT INTO first_table (id, longval) VALUES (1, 120034);


CREATE TABLE second_table (
id NUMBER,
clobval CLOB
);

INSERT INTO second_table (id, clobval) (
SELECT id, TO_LOB(longval) FROM first_table
);

SELECT id, clobval
FROM second_table;

http://www.databasestar.com/oracle-to_lob/

A few examples of the TO_LOB function.

Oracle TO_LOB Function

sql, Oracle

SQL