Drop sequences in current schema - PL/SQL Snipplr Social Repository

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 &apos;drop sequence &apos; || next_row.sequence_name || &apos;&apos;;
   end loop;
end;
/

Initial URL

Initial Description

Initial Title

Drop sequences in current schema

Initial Tags

Oracle

Initial Language

PL/SQL

Choose a language for easy browsing: