set echo off
set heading off
set feedback off
set linesize 512
set pagesize 10000

prompt ------------------------------------------------------
prompt - Compte les lignes de chaque table du user courant --
prompt ------------------------------------------------------

SET TERM OFF 

spool compte_lignes_tables.tmp

SELECT 
   'select '''||table_name||' = ''||count(*) from '
   ||  table_name||' having count(*) > 0;'
FROM 
   user_tables 
WHERE 
   table_name not like 'SYS_IOT_OVER_%' 
ORDER BY 
   table_name;

spool off

SET TERM ON 

@compte_lignes_tables.tmp
