Re: ** HELP ** How to get the number of columns of tables;

In article <4nmfe1$cuj_at_news2.cais.com>, duffy_at_cais2.cais.com (MCC) writes:
> I would like to count the numbers of columns for every tables in the
> database. Instead of using DESCRIBE to get the columns for each table and
> count them, is there any smarter way of doing this?
>
>
> Thanks for your help,
> MCC

-- 
Try:    select table_name, count(*)
	from user_tab_columns
	group by table_name

You could also use view dba_tab_columns if you are a DBA and want to
get all owners and tables.

Jim Richendollar			
Mgr. Prog./Analysis & DBA 		Internet: richendo_at_marshall.edu
Marshall University Computer Center     Phone:    (304)696-3203
Huntington, WV 25755-5320               FAX:      (304)696-3601