Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Select count number of 'columns' in a table.
select count(*) from user_tab_columns where table_name = 'FILL IN THE TABLE
NAME HERE IN ALL CAPS';
HTH
-----Original Message-----
From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca]
Sent: Thursday, August 05, 2004 2:18 PM
To: oracle-l_at_freelists.org
Subject: Select count number of 'columns' in a table.
Hello,
Stupid sql question:
Is there a sql statement that returns the count of the number of columns a table has? NOT the number of rows but the number of columns.
Thanks.
--
Lyndon Tiu
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |