select count(*)
from user_tab_columns
where table_name = <table_name>;

>Merci / Thanks
>Yves Leonard,
>Chef de Projet / Project Leader,
>DDS / SDD,
>RH Coats, 13-I
>Télép>ĥ>one / phone : 613-951-3233,
>couriel / email : yves.[Email address protected]
>

-----Original Message-----
From: laura [mailto:oracledba-ezmlmshield-x6354756.[Email address protected]
Sent: November 2, 2005 10:54 AM
To: LazyDBA Discussion
Subject: How to do a count of columns in a table

I have a huge table that I would like to have a count of how many columns
are in this table.

Also, besides desc table, can I just get a list of columns in the table,
with out the extra field length etc?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page