Cacher is the code snippet organizer for pro developers

DECLARE
Begin
 for c in (select sequence_name from user_sequences) loop
   execute immediate 'drop sequence '||c.sequence_name||'';
 end loop;
 commit;
End;