开发者

Inserting CLOB data with ANT

开发者 https://www.devze.com 2022-12-15 05:14 出处:网络
I am trying to use Ant to initialize my Oracle database by using Ant. I followed this guide: http://www.roseindia.net/tutorials/ant/AntScripttoInsertDatainMysqlTable.shtml

I am trying to use Ant to initialize my Oracle database by using Ant. I followed this guide:

http://www.roseindia.net/tutorials/ant/AntScripttoInsertDatainMysqlTable.shtml

and that works but I was wondering if anyone knows how to insert CLOB data int开发者_如何学JAVAo Oracle tables using Ant.

Thanks in advance.


From what I see in this Ask Tom article, it should be possible to just insert VARCHAR2-values like that:

create table t ( x clob );

insert into t values ( 'MY CLOB CONTENT' );

EDIT
If you want to insert from a file, it should be possible to use the loadfile task to get the file into a property, replace the newlines somehow and use that property in the insert.

0

精彩评论

暂无评论...
验证码 换一张
取 消