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 count the number of NULL columns in a table?

35432Oct 19 2006 — edited Oct 24 2006

Hi everyone!

I'm trying to find a way to count the number of NULL columns in a table and/or identify them (any column where all records have NULL value).

- Is there a SQL, PL/SQL or package function that can do this?
- Can we use the data dictionary tables to help?
- Or... do I have to write a procedure for that?

Any suggestions how?

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2006

Added on Oct 19 2006

47 comments

5,744 views