查看表的记录最多的sqll

2019独角兽企业重金招聘Python工程师标准>>>

 select *
from dba_tables  
 where owner like 'AHBDDATA_DATAPROCESS_HISTORY'  and table_name like 'T_GPS_ALARM_HISTORY_%' order by num_rows desc  NULLS LAST  ;

 

 

 

转载于:https://my.oschina.net/xcOschina/blog/893055