This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

query with the value as null  RSS feed

 
Steve Jiang
Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 37223
519
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
David,


I'm moving this to JDBC as it is not Oracle specific.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!