开发者

Inserting CLOB data with ANT

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜