Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sqlplus: column count of table

sqlplus: column count of table

From: Oliver Meister <nospam1_at_creabyte.ch>
Date: 22 Mar 2005 12:57:42 GMT
Message-ID: <3aaj26F69p9b5U1@individual.net> 





Hi



I'd like to count just the columns of a table.



I've been trying with


            SELECT COUNT (*) FROM all_tab_columns WHERE table_name = 'tablename';
But this does not return what it should.



Do you have any suggestions?



Kind Regards


Oliver
Received on Tue Mar 22 2005 - 06:57:42 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US