Generates sql to return a schema's table name and total number of records
select 'AIRPORTS ', count(*) from DEV_USER_NINE.AIRPORTS;
select 'ASSIGNMENT_CODES ', count(*) from DEV_USER_NINE.ASSIGNMENT_CODES;
select 'BASIC_TABLE ', count(*) from DEV_USER_NINE.BASIC_TABLE;
select 'CABIN_CLASSES ', count(*) from DEV_USER_NINE.CABIN_CLASSES;
select 'CITIES ', count(*) from DEV_USER_NINE.CITIES;
select 'COUNTRIES ', count(*) from DEV_USER_NINE.COUNTRIES;
select 'COUNTRIES_NPK ', count(*) from DEV_USER_NINE.COUNTRIES_NPK;
select 'COUNTRY_CONDITIONS ', count(*) from DEV_USER_NINE.COUNTRY_CONDITIONS;
select 'COUNTRY_OPTIONS ', count(*) from DEV_USER_NINE.COUNTRY_OPTIONS;
select 'COUNTRY_REF_CODES ', count(*) from DEV_USER_NINE.COUNTRY_REF_CODES;
select 'DEMO_CITIES ', count(*) from DEV_USER_NINE.DEMO_CITIES;
select 'DEMO_COUNTRIES ', count(*) from DEV_USER_NINE.DEMO_COUNTRIES;
select 'DEMO_CUSTOMERS ', count(*) from DEV_USER_NINE.DEMO_CUSTOMERS;
select 'DETAILED_ERROR_CODES ', count(*) from DEV_USER_NINE.DETAILED_ERROR_CODES;
select 'DISTRIBUTION_OPTIONS ', count(*) from DEV_USER_NINE.DISTRIBUTION_OPTIONS;
select 'FK_TABLE ', count(*) from DEV_USER_NINE.FK_TABLE;
select 'FLIGHTS ', count(*) from DEV_USER_NINE.FLIGHTS;
select 'GENERAL_PARAMETERS ', count(*) from DEV_USER_NINE.GENERAL_PARAMETERS;
select 'HELP_TEXTS ', count(*) from DEV_USER_NINE.HELP_TEXTS;
select 'INCIDENTS ', count(*) from DEV_USER_NINE.INCIDENTS;
select 'INCIDENT_CODES ', count(*) from DEV_USER_NINE.INCIDENT_CODES;
select 'INCIDENT_CODES_NPK ', count(*) from DEV_USER_NINE.INCIDENT_CODES_NPK;
select 'LISTS ', count(*) from DEV_USER_NINE.LISTS;
select 'MESSAGE_DISTRIBUTION ', count(*) from DEV_USER_NINE.MESSAGE_DISTRIBUTION;
select 'MESSAGE_LIST ', count(*) from DEV_USER_NINE.MESSAGE_LIST;
select 'PEOPLES ', count(*) from DEV_USER_NINE.PEOPLES;
select 'PK_TABLE ', count(*) from DEV_USER_NINE.PK_TABLE;
select 'PRODUCTS ', count(*) from DEV_USER_NINE.PRODUCTS;
select 'SUBQUERY_FIVE ', count(*) from DEV_USER_NINE.SUBQUERY_FIVE;
select 'TEST_ASTERISK ', count(*) from DEV_USER_NINE.TEST_ASTERISK;
select 'TITLE_CODES ', count(*) from DEV_USER_NINE.TITLE_CODES;
select 'USERNAMES ', count(*) from DEV_USER_NINE.USERNAMES;
32 rows selected.
prompt
set head off
prompt Enter # for current user
prompt
accept x_owner prompt "Owner : "
spool ccount.rpt
select 'select ' || '''' || rpad( table_name, 30 ) || '''' || ', count(*) from ' || owner || '.' || table_name || ';'
from dba_tables
where owner like decode( '&x_owner', '#', user, upper( '%&x_owner%' ) )
order by table_name;
spool off