How to insert empty_clob() from java to Oracle

Question

I am having an NCLOB column in oracle. 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

javanna · Accepted Answer · 2011-03-17 11:00:21Z

3

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.

edited Mar 17, 2011 at 11:00

answered Mar 17, 2011 at 10:38

javanna

60.4k14 gold badges147 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert empty_clob() from java to Oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related