执行SQL如下:
select t.table_name,a.comments,t.num_rows from user_tables t
left join user_tab_comments a on a.table_name = t.TABLE_NAME
执行结果:
执行SQL如下:
select t.table_name,a.comments,t.num_rows from user_tables t
left join user_tab_comments a on a.table_name = t.TABLE_NAME
执行结果: