1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| declare
date_sousc date;
montant number;
code number;
code_ass number;
code_comp number;
mat number;
begin
for code in 1..800000 loop
select floor(dbms_random.value(1,200000))into code_ass from dual;
select floor(dbms_random.value(1,20.2))into code_comp from dual;
select floor(dbms_random.value(1,40000.2))into mat from dual;
select trunc(dbms_random.value(5000,100000),2)into montant from dual;
select to_date(trunc(dbms_random.value(to_char(date '2014-01-01','J'),to_char(date '2016-12-31','J')))
,'J')into date_sousc from dual;
insert into contrat values(code,date_sousc,montant,code_ass,code_comp,mat);
end loop;
commit;
end;
/ |
Partager