declare i number; j number; k number := 0; begin for i in 1..60 loop for j in 1..10000 loop k := k + 1; insert into sales values ( k, i, 'D'||mod(i,20), dbms_random.value(1000000,2000000), dbms_random.value(1,10), 'INITIAL' ); end loop; end loop; end; /