Oracle查询所有表名&数据量&字段数量

时间:2025-03-11 16:37:21
select b.table_name,,b.num_rows,   
from user_tables b
	left join (
	SELECT
	a.table_name,
	count( a.table_name ) clo 
FROM
	user_tab_columns a
GROUP BY
	a.table_name 
	) c on c.table_name = b.table_name
	left join (
	 select * from user_tab_comments where TABLE_NAME not like '%$%'
	) d on d.table_name = b.table_name