declare
begin
for tab in (select table_name from user_tables) loop
execute immediate 'truncate table ' || tab.table_name;
execute immediate 'drop table ' || tab.table_name;
end loop;
end;
/
begin
for tab in (select table_name from user_tables) loop
execute immediate 'truncate table ' || tab.table_name;
execute immediate 'drop table ' || tab.table_name;
end loop;
end;
/