22 lines
327 B
Plaintext
Executable File
22 lines
327 B
Plaintext
Executable File
alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
|
|
|
|
drop table u0.t0 purge;
|
|
create table u0.t0(d date);
|
|
|
|
declare
|
|
|
|
i integer;
|
|
maxi integer default 10000000;
|
|
|
|
|
|
begin
|
|
for i in 1..maxi loop
|
|
begin
|
|
insert into u0.t0 values (sysdate);
|
|
commit;
|
|
sys.dbms_session.sleep(1);
|
|
end;
|
|
end loop;
|
|
end;
|
|
/
|