plsql insert 10000 data into 3 tables : I have 3 tables. tours, tour_hotels and tour_transfers. Tour table has columns named id, tour_name, start_date. Tour_hotels table has columns named id, tour_id, hotel_name. Tour_transfers table has id, tour_id, from_where, to_where columns. Now I need to insert 10000 rows into each table. My code must be plsql and for loop. I must use only one for loop to insert all datas into 3 tables. And I must pay attention, id in tours table must match with tour_id in tour_hotels and tour_transfers tables. I am new learner in plsql, so please write sample and simple code for me. 

begin
    for i in 1 .. 10000 loop
        insert into tour.tours values
        (i, ('Tour ' || i), trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/15, 'ddd'), trunc(to_date('01/03/2019', 'mm/dd/yyyy')+i/15+i/777, 'ddd'),
        trunc(2+i/777), trunc(100 + i/6), trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/99, 'ddd'), trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/98, 'ddd'),
        1, ('Country ' || trunc(i/60)));
        
        if(mod(i, 300) = 0) then
            insert into tour.tour_hotels 
            values
            (i, i, ('Hotel ' || i), ('Country ' || trunc(i/60)), 3 + mod(i, 3), 0, 0, 1, trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/99, 'ddd'),
            trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/98, 'ddd'), 1);
        elsif (mod(i, 200) = 0) then
            insert into tour.tour_hotels 
            values
            (i, i, ('Hotel ' || i), ('Country ' || trunc(i/60)), 3 + mod(i, 3), 1, 0, 0, trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/99, 'ddd'),
            trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/98, 'ddd'), 1);
        elsif (mod(i, 700) = 0) then
            insert into tour.tour_hotels 
            values
            (i, i, ('Hotel ' || i), ('Country ' || trunc(i/60)), 3 + mod(i, 3), 1, 1, 1, trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/99, 'ddd'),
            trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/98, 'ddd'), 1);
        else
            insert into tour.tour_hotels 
            values
            (i, i, ('Hotel ' || i), ('Country ' || trunc(i/60)), 3 + mod(i, 3), 1, 0, 1, trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/99, 'ddd'),
            trunc(to_date('01/01/2019', 'mm/dd/yyyy')+i/98, 'ddd'), 1);
        end if;
        
        insert into TOUR.TOUR_TRANSFERS values
        (i, i, ('Buradan ' || i), ('Buraya ' || i), trunc(to_date('01/01/2019', 'dd/mm/yyyy')+i/99, 'ddd'),
            trunc(to_date('01/01/2019', 'dd/mm/yyyy')+i/98, 'ddd'), 1);
    end loop;
end;