SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using <> or != on a NULL

582145Nov 22 2007 — edited Dec 7 2007

Hi,

This is probably a very easy question..

When I try to SELECT some rows based on tableA.col1 <> tableB.col1, I get less rows than expected back. I think it's because some of the tableA.col1 are NULL and tableB.col2 have values.

Is there a way to check for equality w/out having to use IS NULL and IS NOT NULL?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2008

Added on Nov 22 2007

43 comments

7,072 views