Take a look at DBA_TAB_COLUMNS


Ian
Work: 0151 235 2657
Mobile: 07725 667438


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




*****************************************************************************
This email and its attachments are confidential and are intended for the above named recipient only. If this has come to you in error, please notify the sender immediately and delete this email from your system. You must take no action based on this, nor must you copy or disclose it or any part of its contents to any person or organisation. Statements and opinions contained in this email may not necessarily represent those of Littlewoods Shop Direct Group Limited or its subsidiaries. Please note that email communications may be monitored. The registered office of Littlewoods Shop Direct Group Limited is 100 Old Hall Street Liverpool L70 1AB registered number 5059352
*****************************************************************************




This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

Oracle LazyDBA home page