开发者

How to insert empty_clob() from java to Oracle

开发者 https://www.devze.com 2023-02-17 04:40 出处:网络
I am having an NCLOB column in oracl开发者_Go百科e. When I create a row, I need to insert an empty_clob() using normal java insert query.

I am having an NCLOB column in oracl开发者_Go百科e. When I create a row, I need to insert an empty_clob() using normal java insert query. Does anyone know how this is done? I am looking for something like the one below from java.

INSERT INTO MY_TABLE VALUES(1,'Abraham','empty_clob');

Thanks and Regards, Abraham Menacherry


You should correct your insert statement:

INSERT INTO MY_TABLE VALUES(1,'Abraham',empty_clob());

You should also take a look here.

The empty_clob function is also useful as default value for the clob column.

0

精彩评论

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