12:11:55 SQL> create or replace procedure p_test as
12:12:26 2 v_num number;
12:12:34 3 begin
12:12:37 4 execute immediate 'create table test(coll number)';
12:13:08 5 for i in 1..100 loop
12:13:29 6 execute immediate 'insert into test values('||i||')';
12:13:54 7 end loop;
12:14:01 8 commit;
12:14:12 9 end p_test;
12:14:16 10 /过程已创建。已用时间: 00: 00: 00.28
12:15:38 SQL> exec p_test;PL/SQL 过程已成功完成。已用时间: 00: 00: 00.34
12:15:44 SQL> select count(1) from test; COUNT(1)
----------
100已用时间: 00: 00: 00.16
12:15:55 SQL>
12:12:26 2 v_num number;
12:12:34 3 begin
12:12:37 4 execute immediate 'create table test(coll number)';
12:13:08 5 for i in 1..100 loop
12:13:29 6 execute immediate 'insert into test values('||i||')';
12:13:54 7 end loop;
12:14:01 8 commit;
12:14:12 9 end p_test;
12:14:16 10 /过程已创建。已用时间: 00: 00: 00.28
12:15:38 SQL> exec p_test;PL/SQL 过程已成功完成。已用时间: 00: 00: 00.34
12:15:44 SQL> select count(1) from test; COUNT(1)
----------
100已用时间: 00: 00: 00.16
12:15:55 SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货