Return to Snippet

Revision: 16489
at August 6, 2009 06:00 by kamilch


Updated Code
-- drop sequences from current schema
declare
   sequence_name varchar2(128);
   cursor usersequences is select * from user_sequences;
begin
   for next_row in usersequences
   loop
      execute immediate 'drop sequence ' || next_row.sequence_name || '';
   end loop;
end;
/

Revision: 16488
at August 6, 2009 05:58 by kamilch


Initial Code
-- drop sequences from current schema
declare
   sequence_name varchar2(128);
   cursor usersequences is select * from user_sequences;
begin
   for next_row in usersequences
   loop
      execute immediate 'drop sequence ' || next_row.sequence_name || '';
   end loop;
end;
/

Initial URL


Initial Description


Initial Title
Drop sequences in current schema

Initial Tags
Oracle

Initial Language
PL/SQL