我写的,不知道有没有更好的,也学习下select count(*), table_name from user_tab_columns where table_name in (select table_name from cat) group by table_name
select * from user_col_comments where table_name='CODE_RULE'
select a.tname,count(*) field_count from tab a,user_col_comments b where tabtype='TABLE' and a.tname=b.table_name group by a.tname
precipitant(塞北的雪) 正解
我反倒觉得 helloworld 的方法 要好些。
select count(*), table_name from user_tab_columns where table_name in (select table_name from cat) group by table_name ++++++++++++++++++++++++++++++++++++++++如果非要这样得话,还是改成表关联好一些,
where table_name in (select table_name from cat)
group by table_name
where table_name in (select table_name from cat)
group by table_name
++++++++++++++++++++++++++++++++++++++++如果非要这样得话,还是改成表关联好一些,