inserting CLOB from sqlplus
how to insert data intoa lob column via sqlplus
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.
The whole difference between a little boy and an adult man is the price of toys
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
But you can use dbms_lob to read a flat file and load that with dbms_lob.
this space intentionally left blank
check this out
Check this link, it has the answer you're looking for
Click Here to Expand Forum to Full Width