oracle

select a.table_name,count(a.COLUMN_NAME) from all_tab_columns a where a.owner = '表' group by a.TABLE_NAME;

mysql:

SELECT a.`TABLE_NAME`,COUNT(*) FROM  COLUMNS a WHERE a.`TABLE_SCHEMA` = '表' GROUP BY a.`TABLE_NAME` ORDER BY a.`TABLE_NAME`