pro_drop_seq
------------------------------------------------
-- Export file for user ZHIFU --
-- Created by zhanglei on 2011-9-16, 15:21:16 --
------------------------------------------------
-- Export file for user ZHIFU --
-- Created by zhanglei on 2011-9-16, 15:21:16 --
------------------------------------------------
spool pro_drop_seq.log
prompt
prompt Creating procedure PRO_DROP_SEQ
prompt ===============================
prompt
create or replace procedure zhifu.pro_drop_seq
is
v_sql VARCHAR2(2000);
begin
prompt Creating procedure PRO_DROP_SEQ
prompt ===============================
prompt
create or replace procedure zhifu.pro_drop_seq
is
v_sql VARCHAR2(2000);
begin
for c1 in (select sequence_name from user_sequences ) loop
v_sql:= 'drop sequence '|| c1.sequence_name;
execute immediate v_sql ;
end loop;
end pro_drop_seq;
/
execute immediate v_sql ;
end loop;
end pro_drop_seq;
/
spool off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9252210/viewspace-707722/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
pro_create_seq
请登录后发表评论
登录
全部评论
