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!

Finding empty columns

362992Oct 30 2002
Hello everyone

As part of an effort in the company to analyze the data in our databases, I've been asked to find out what columns are not being populated by our systems.

I had planned on runnin many:

select count(1) from <table> where <fieldname> = NULL

but it seems like we have over 100,000 fields in our database, so, this task would take a very long time. I imagine there must be a better way to find what fields are not being populated??

Any suggestion will be appretiated.

-OG
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2002
Added on Oct 30 2002
8 comments
1,866 views