How to count the number of columns in a table using SQL

Question

How to count the number of columns in a table using SQL   I am using Oracle 11g  Please help  t

User · Accepted Answer

select count     from user tab columns where table name  MYTABLE  --use upper case   Instead of uppercase you can use lower function  Ex   select count    from user tab columns where lower table name   table name

User · Answer

Old question - but I recently needed this along with the row count    here is a query for both - sorted by row count desc   SELECT t owner          t table name          t num rows          Count     FROM   all tables t         LEFT JOIN all tab columns c                ON t table name   c table name  WHERE  num rows IS NOT NULL  GROUP  BY t owner             t table name             t num rows  ORDER  BY t num rows DESC

User · Answer

Maybe something like this   SELECT count    FROM user tab columns WHERE table name    FOO    this will count number of columns in a the table FOO  You can also just  select count    from all tab columns where owner  BAR  and table name  FOO     where the owner is schema and note that Table Names are upper case

[sql] How to count the number of columns in a table using SQL?

Examples related to sql

Examples related to oracle