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!

SQL query to not to exclude NULLS

SeshuGiriAug 31 2010 — edited Aug 31 2010

Hi,

I have a column in table

Type
ABC
XYZ
	-- NULL
	-- NULL

When I write sql statement to exclude Type = 'ABC', the query also excluding NULLs. How to avoid (include nulls) that?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2010

Added on Aug 31 2010

8 comments

2,590 views