select table_name,(select count(*) from user_tab_columns b where b.TABLE_NAME=a.TABLE_NAME) from user_tab_columns a;