Oracle清查table資料筆數語法

select table_name, 
       to_number(extractvalue
                  (xmltype
                   (dbms_xmlgen.getxml('select count(0) c from '||owner||'.'||table_name))
                   ,'/ROWSET/ROW/C')
                 ) as cc 
from all_tables
where owner = '這邊輸入你設定的owner'
order by cc