advanced code snippet search
kamilch on 08/06/09
08/06/09 06:00am08/06/09 05:58am
-- drop sequences from current schemaDECLARE 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;/
Report this snippet
You need to login to post a comment.