SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> BEGIN
2
3 FOR i IN (SELECT table_name
4 FROM user_tables
5 WHERE table_name = 'DUMMY' ) LOOP
6 EXECUTE IMMEDIATE 'DROP TABLE dummy';
7
8 END LOOP;
9
10 END;
11 /
PL/SQL procedure successfully completed.
SQL>