Analysing null / not null data

Hi all,

I want to analyse a 9i table in a way that will provide me with summary information about the contents of each column, like this:

col_1 : this column contains a null in 1000 rows
col_2 : this column contains a null in 500 rows
col_3 : this column contains a null in 0 rows

That's all I need - either the total number of rows where the column is null, or the total number of rows where it is not null. I'm hoping there's a portable method that will work for any table, without me having to name each table / column individually. Does anyone know of a way to achieve it?

TIA
Tarby Received on Tue Jan 31 2006 - 04:05:28 CST