17 lines
379 B
SQL
17 lines
379 B
SQL
alter session set plsql_optimize_level=0;
|
|
|
|
declare
|
|
l_sid number;
|
|
begin
|
|
|
|
select sid into l_sid from v$mystat where rownum = 1;
|
|
|
|
while true loop
|
|
execute immediate 'insert into t values('||to_char(l_sid)||')';
|
|
execute immediate 'commit';
|
|
execute immediate 'delete from t where a = '||to_char(l_sid);
|
|
execute immediate 'commit';
|
|
end loop;
|
|
end;
|
|
/
|