I have tried but not able insert the values into the summary table. Please assume all the tables are created.
Declare
tot_records number(10);
records_loaded number(10);
process_start_time timestamp;
lv_count number(10);
begin
tot_records := select count(1) into lv_count from employees;
insert into department select * from employees;
records_loaded := sql%rowcount;
process_start_time := current_timestamp;
insert into summary(total,tot_loads,start_time) values(tot_records,records_loaded,process_start_time);
end;