Numero righe delle tabelle
Di seguito uno script sql che estrae il numero di righe di ogni tabella.
$ vi count_row_table.sql
SET SERVEROUTPUT ON
spool count_row_table.log
DECLARE
val NUMBER;
BEGIN
FOR I IN (
select TABLE_NAME from dba_tables where owner='A20' and table_name IN ( 'T11R_ALIA','T1R_MGRU','T1119R_PFIS','T1123V_MPAR_ALIA_PFIS','T1132R_GOVE','T1134R_GRUP','T1141R_OPAR','T1143V_ALIA_PFIS_MPAR','T1350R_OMON_IOT')
)
LOOP
EXECUTE IMMEDIATE 'SELECT count(*) FROM ' || i.table_name INTO val;
DBMS_OUTPUT.PUT_LINE (i.table_name || ' ==> ' || val );
END LOOP;
END;
/
spool off
exit