------------------------------------------------
-- 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博客 ” ,链接:http://blog.itpub.net/9252210/viewspace-707720/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9252210/viewspace-707720/