SQL>
SQL> set echo on
SQL> set serveroutput on
SQL> begin
2 for i in 1 .. 100 loop
3 begin
4 execute immediate 'drop table t'||i;
5 exception
6 when others then null;
7 end;
8 execute immediate 'create table t'||i||' ( dummy char(1) )';
9 execute immediate 'insert into t'||i||' values ( ''x'' )';
10 end loop;
11 end;
12 /
PL/SQL procedure successfully completed.
SQL>