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

advertisements

This question already has an answer here:

  • Number of columns 5 answers

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

I am using Oracle 11g

Please help. t.


select count(*)
from user_tab_columns
where table_name='MYTABLE' --use upper case