User Tools

Site Tools


oracle:sql:table:dba_table_names

Oracle - SQL - Table - DBA Table Names

To add

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;
SELECT owner, TABLE_NAME, 
'select count(*) from '||TABLE_NAME||';' 
FROM dba_tables 
WHERE owner = 'DB_DESIGNER';
SELECT
 TABLE_NAME,
 num_rows counter
FROM
 dba_tables
WHERE
 owner = 'XXX'
ORDER BY
 TABLE_NAME;
oracle/sql/table/dba_table_names.txt · Last modified: 2021/08/08 18:02 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki