File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes how to the setNull() method Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to the setNull() method" Watch "how to the setNull() method" New topic

how to the setNull() method

ramchander yshetti
Ranch Hand

Joined: Apr 22, 2006
Posts: 97
i created a table student(sno number(2),sname varchar2(15));
i want to set null to the, sno and sname.

->i tried using the
insert into student values(?,?);


-> but it is not working.
->can any one suggest me.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33106

Are there any other fields? You can't set all the fields to null in a row - it would have no meaning.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: how to the setNull() method
It's not a secret anymore!