Skip to Main Content

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!

How to select columns with null values

649638Feb 5 2009 — edited Dec 16 2009
HI

In my table ‘A’ I have 10 columns and 30,000 records. I need all those columns whose value is null for all the records.

For example in the below table column 'suffix' is null for all the records. So I want column suffix to be selected.

Name Suffix Street

James 1100 Washington street
Richard 273 GEORGIA ST
Arnold 3018 OAKHILL AVE
MICHAEL 834 E 161ST ST
Joseph 410 PINE AVE


Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2010
Added on Feb 5 2009
13 comments
45,615 views