select count(*) from user_tab_columns t where t.TABLE_NAME='TABLE_NAME';

SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME='TABLE_NAME' ORDER
BY COLUMN_ID

-----Original Message-----
From: laura
[mailto:oracledba-ezmlmshield-x6354756.[Email address protected]
Sent: Wednesday, November 02, 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