create table test1(code varchar(5), name varchar2(10),ch_date date);--
create table test2(id number(5),code varchar(5), name varchar2(5),ch_date date,load_id number(5));--
create table log (id number(5),start_date date,end_date date,num_rows number(5),num_err number(5),num_rows_ins number(5));--num_rows количесво строк, num_err кол-во  ошибок при ставке, num_rows_ins-количество вставлено 
create table error (load_id number(5),code varchar(5),err varchar2(20));

insert into test1 values('001','NM1','01.07.2016');
insert into test1 values('002','NM2','01.07.2016');
insert into test1 values('003','NM3','01.07.2016');
insert into test1 values('001','NM11','05.07.2016');
insert into test1 values('006','ABCDEFG','06.07.2016');