0
Query :
select table_name
, to_number
( extractvalue
( dbms_xmlgen.getxmltype('select count(*) c from ' || table_name)
, '/ROWSET/ROW/C'
)
) cnt
from user_tables
order by table_name
Example :select table_name
, to_number
( extractvalue
( dbms_xmlgen.getxmltype('select count(*) c from ' || table_name)
, '/ROWSET/ROW/C'
)
) cnt
from user_tables
order by table_name
0Awesome Comments!