count all table in a database in oracle query

SELECT COUNT(*) FROM USER_TABLES;

or

SELECT Count(*) FROM DBA_TABLES; 

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

select count(*) 
from user_tab_columns
where table_name='table name'