20 lines
558 B
MySQL
20 lines
558 B
MySQL
|
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
||
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
||
|
|
|
||
|
|
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;
|
||
|
|
/
|