File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes query with the value as null Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "query with the value as null" Watch "query with the value as null" New topic
Author

query with the value as null

Steve Jiang
Ranch Hand

Joined: May 17, 2004
Posts: 107
I get 1000 row with with

select * from table1

but less row with
select * from table1 where scheduling =2; 400 row
and
select * from table1 where scheduling !=2; 200 row.

I checked the DB, there is data (400 row ) schduling as null. how can get the result for scheduling as null?

Thanks a lot
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31057
    
232

David,


I'm moving this to JDBC as it is not Oracle specific.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: query with the value as null