Re: Analysing null / not null data

The dba_tab_columns dictionary view contains an estimated count of nulls in each column based on the optimizer statistics gathering process. The view also identifies how many unique values exist for each column, if is is nullable, and a few other interesting facts. Depending on why you want to create your summary this view may be useful.

Otherwise as Daniel said select count(*) from x where col1 is null. You will only need dynamic SQL if you are trying to write a generic routine that you can use on any of your tables.

HTH -- Mark D Powell -- Received on Tue Jan 31 2006 - 19:21:34 CST