DECLARE
v_sql VARCHAR2(4000);
v_count INTEGER;
v_sum INTEGER;
v_cnt INTEGER;
TYPE table_type IS TABLE OF User_All_Tables%ROWTYPE INDEX BY BINARY_INTEGER;
v_table table_type;
CURSOR cour IS SELECT * FROM User_All_Tables WHERE table_name LIKE 'FJ%';
BEGIN
v_sum:=0;v_count:=0;
OPEN cour;
FETCH cour BULK COLLECT INTO v_table;
CLOSE cour;
FOR i IN 1..v_table.COUNT LOOP
v_sql:='SELECT COUNT(*) FROM '||v_table(i).table_name;
EXECUTE IMMEDIATE v_sql INTO v_count;
v_sum:=v_sum+v_count;
END LOOP;
dbms_output.put_line(v_sum);