oracle procedure

最新推荐文章于 2019-03-12 10:58:54 发布

原创最新推荐文章于 2019-03-12 10:58:54 发布 · 587 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #email #insert

Oracle 专栏收录该内容

7 篇文章

订阅专栏

create or replace Procedure test (id in number)
as i number;
name1 varchar2(50);
email1 varchar2(50);
begin
   i := 1;
   delete from ofgatewayregistration;
   while i <= id LOOP
       begin
           name1 := '0086.luoaz'||i||'@smart.ph';
           email1 := 'luoaz'||i||'@gmail.com';
           -- DBMS_OUTPUT.put_line('--------'||name1);
           insert into ofgatewayregistration values (i,name1,'google',email1,'e3f341743d40fd6c5b6a45e072602b0d','','00000000','00000000');
           commit;
           i := i+1;
       end;
   end loop;
end test;
select count(*) from ofgatewayregistration;

 insert into ofgatewayregistration values (1,'admin1@smart.ph','google','test1@gmail.com','e3f341743d40fd6c5b6a45e072602b0d','','00000000','00000000');

declare
begin
  test(100000);
end;