I have seen references for the to_lob function, but it doesn't seem to be working in my insert statement.
I am using Oracle 8.0.5.
table1 consists of a number field and a clob field.
table2 consists of a number field and a long field.
example: insert into table1 select numberfield, to_lob(longfield) from table2 where numberfield = 123;
Is there another way to do this without writing to a flatfile and reading into a clob?