pro_create_seq
------------------------------------------------
-- Export file for user ZHIFU --
-- Created by zhanglei on 2011-9-16, 15:20:55 --
------------------------------------------------
-- Export file for user ZHIFU --
-- Created by zhanglei on 2011-9-16, 15:20:55 --
------------------------------------------------
spool pro_create_seq.log
prompt
prompt Creating procedure PRO_CREATE_SEQ
prompt =================================
prompt
create or replace procedure zhifu.pro_create_seq
is
i number;
v_sql varchar(2000);
begin
i:=1;
for i in 1 .. 20000 loop
v_sql := 'create sequence test_seq_'||i||' minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20 ';
execute immediate v_sql ;
end loop;
end pro_create_seq;
/
prompt Creating procedure PRO_CREATE_SEQ
prompt =================================
prompt
create or replace procedure zhifu.pro_create_seq
is
i number;
v_sql varchar(2000);
begin
i:=1;
for i in 1 .. 20000 loop
v_sql := 'create sequence test_seq_'||i||' minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20 ';
execute immediate v_sql ;
end loop;
end pro_create_seq;
/
spool off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9252210/viewspace-707720/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
blog的访问量超过65000,谨此记录
下一篇：
pro_drop_seq
请登录后发表评论
登录
全部评论
