Column Count in Table

From: Lee Parsons <lparsons_at_eskimo.com>
Date: Fri, 24 Mar 1995 23:48:58 GMT
Message-ID: <D5yy5s.GJI_at_eskimo.com>


The Data Dictionary Policeman just left my office and wants a report that lists a count of non-null values for a particular table. Of course what he is looking for is obsolete columns and if i give it to him his next request will be for a report on ALL tables.

Since this is almost a reasonable request I told him I would think about it.

  1. anybody done this before?
  2. Any idea how to do this with out doing a individual tablescan of the table for each column? Seems like there should be a way of doing this with just one table scan. I also thought there was someplace to get this information after a analyze table compute but I cant find it and oracle sez no dice.

Thoughts?

--
Regards,

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com
Received on Sat Mar 25 1995 - 00:48:58 CET

Original text of this message