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

oracle, sql

Solution

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';

Problem

Original source

Related problems

• Number of columns
• Number of columns