Call 'execute immediate' to drop table, create table and insert data
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>