-- DML1.sql
-- This is the dml1.sql SQL
--
def startv=&1
def endv=&2
def wait=&3
def batch=&4
def opt='write &wait &batch';
begin
  loop
    update op_test
    set    created=sysdate,
           namespace=1
    where  object_id=trunc(dbms_random.value(&startv,&endv));
    commit &opt;
    dbms_lock.sleep((1/50)*exp(0.50*dbms_random.normal));
  end loop;
end;
/
