MeowOWO的博客

文章目录oracle字段数查询数据量查询总结1.字段数2.拼接收集统计信息的sql3.执行收集统计信息的sql4.数据量mysql字段数数据量oracle字段数查询select table_name,count (column_name)from user_tab_columns where table_name in (select t.table_name from user_tables t) group by table_name order by table_name desc;