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

MCC, Try doing a count of rows from the user_tab_columns table, for the tables you want or for a complete list get the table_name and group by it.

Hope this helps,

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

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