How to insert empty_clob() from java to Oracle
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.
精彩评论