demo01.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 29 行

drop table t;
create table t ( x int );
create or replace procedure proc1
as
begin
    for i in 1 .. 10000
    loop
        execute immediate
        'insert into t values ( :x )' using i;
    end loop;
end;
/
create or replace procedure proc2
as
begin
    for i in 1 .. 10000
    loop
        execute immediate
        'insert into t values ( '||i||')';
    end loop;
end;
/
exec runstats_pkg.rs_start
exec proc1
exec runstats_pkg.rs_middle
exec proc2
exec runstats_pkg.rs_stop(1000)