counting rows for all database tables

The following SQL Code can be used to display the rowcount for all (Orale BI Applications) tables:

select table_name,
to_number(extractvalue(xmltype
(dbms_xmlgen.getxml('select count(*) c from '||table_name))
,'/ROWSET/ROW/C')) count
from user_tables
order by table_name;

image

for further reference, check here.