Begin
-- Drop all tables for current logged in user.
for t in (select table_name from user_tables) loop
execute immediate ('drop table ' || t.table_name);
end loop;
-- Drop all views for current logged in user.
for v in (select view_name from user_views) loop
execute immediate ('drop view ' || v.view_name);
end loop;
-- Drop all sequences for current logged in user.
for s in (select sequence_name from user_sequences) loop
execute immediate ('drop sequence ' || s.sequence_name);
end loop;
End;