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