define TAB=’&1′
declare
cursor c1 is
select table_name
from user_tables
where table_name like ‘&TAB%’;
v_sql varchar2(4000);
begin
for r1 in c1 loop
v_sql := ‘drop table ‘||r1.table_name;
dbms_output.put_line(v_sql);
execute immediate v_sql;
end loop;
end;
/