showyuhehui
showyuhehui
2017-10-31 02:47

oracle写了一个储存过程重置序列,执行时报错,详见附件,请各位帮忙看看

1
  • oracle
  • 储存过程

create or replace procedure reset_seq(data_seq in varchar2) is
v_seq varchar2(1000);
begin
select 'drop sequence' || data_seq into v_seq from dual;
execute immediate v_seq;图片说明
select 'create sequence' || data_seq ||
'minvalue 1 maxvalue 999999 start with 1 increment by 1 cache 20'
into v_seq
from dual;
execute immediate v_seq;
end;

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答