Home -> Usenet -> comp.databases.oracle -> Re: ** HELP ** How to get the number of columns of tables;

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

From: E. Sedney <101740.245_at_CompuServe.COM>
Date: 1996/05/20
Message-ID: <4nqauf$hm6$1_at_mhafc.production.compuserve.com>#1/1 








Hi,



The reason why you would like to to this is not clear to me, but 
if you want to count the columns in a table then you could use 
this query: select count(*) from dba_tab_columns 


            where owner = upper('&1') and table_name = 
upper('&2');



In this specific table you can retrieve all the information about 
columns.



Good luck


-- 
E. Sedney
Oracle NL
ESEDNEY_at_NL.ORACLE.COM


Received on Mon May 20 1996 - 00:00:00 CEST












Original text of this message