Re: finding blank columns

gpanda28_at_gmail.com wrote:
> Hi all
>
> I want to find out tables having blank columns,
> is there any easy way to finding them.
>
> pl. help
>
>
> thanks
>
> GP

exec dbms_stats.gather_schema_stats('<schema_name>');

SELECT column_name, num_nulls
FROM user_tab_columns
WHERE table_name = <table_name>;

Daniel Morgan
www.psoug.org Received on Wed May 03 2006 - 12:09:55 CDT