Calling Sql Guys..query Help

[Cherry25]

Hello all. I am learning Oracle pl/sql. I want to know how can we find empty columns in a table. (How to find columns which have all null values in it?) I tried using count(column_name), but the drawback is I've to go column by column which doesn't look effective to me. Can u guys pls help me with this..

Thanks

[me1233]

When you say empty columns you mean column which are completely null?



Check this site for latest salary and visa trends: [url="http://www.visasquare.com/"]http://www.visasquare.com[/url]