sqlplus / as sysdba <<EOF
drop table t1;
create table t1(id number,check_for_dg varchar2(30));
declare
i number;
begin
delete t1 where 1=1;
insert into t1 values(1,to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'));
for i in 1..720 loop
update t1 set check_for_dg=to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') where id=1;
dbms_lock.sleep(5);
commit;
end loop;
end;
/
EOF
drop table t1;
create table t1(id number,check_for_dg varchar2(30));
declare
i number;
begin
delete t1 where 1=1;
insert into t1 values(1,to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'));
for i in 1..720 loop
update t1 set check_for_dg=to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') where id=1;
dbms_lock.sleep(5);
commit;
end loop;
end;
/
EOF