====== Oracle - SQL - Table - DBA Table Names ======

===== To add =====

<code sql>
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;
</code>


<code sql>
select owner, table_name, 
'select count(*) from '||table_name||';' 
from dba_tables 
where owner = 'DB_DESIGNER';
</code>

<code sql>
select
 table_name,
 num_rows counter
from
 dba_tables
where
 owner = 'XXX'
order by
 table_name;
</code>