how to insert data intoa lob column via sqlplus
mytest table
test1- number1
test2 clob
i know i cannot do this
insert into mytest values(test1,'test2');
any help is much appreciated
Printable View
how to insert data intoa lob column via sqlplus
mytest table
test1- number1
test2 clob
i know i cannot do this
insert into mytest values(test1,'test2');
any help is much appreciated
Of course you cannot do that because the value test1 is not a number. String literals are OK for inserting into a clob.
In regards to your CLOB column question...
1- You cannot directly insert a string larger than 4000 bytes in your CLOB column
2- For a string larger than 4000 you have to call a procedure, check dbms_lob.write
3- For a string larger than 32000 bytes you would have to loop to append data in 32K chunks, check dbms_lob.writeappend
But you can use dbms_lob to read a flat file and load that with dbms_lob.
Check this link, it has the answer you're looking for
http://asktom.oracle.com/pls/asktom/...D:367980988799
thank you