Skip to Main Content
Forums

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 get a list of all columns that have NULL values in all the rows

549855Feb 13 2008 — edited Feb 13 2008
Hi,
I have a big table with about 100 columns.
The table have appx. 1,000,000 rows.
Few of the column have NULL value IN ALL THE RECORDS.
I would like to know, how to get a list of all the columns , that have NULL values in all the rows.
Thank You.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2008
Added on Feb 13 2008
4 comments
3,334 views