create or replace procedure proc1 as
CURSOR cur IS select a.config_id, a.code, a.creation_date, a.last_update_date from table_a a, table_b b where a.config_id = b.config_id and a.last_update_date > b.last_update_date;
CURSOR cur2 IS select * from table_a a where a.config_id not in (select config_id from table_b);
p_code number; p_creation_date date;
p_last_updat date;
p_config_id varchar2(32);
begin
FOR cur_result in cur
LOOP
p_code := cur_result.code;
p_creation_date := cur_result.creation_date;
p_last_updat := cur_result.last_update_date;
p_config_id := cur_result.config_id;
update table_b set code=p_code, creation_date=p_creation_date, last_update_date=p_last_updat where config_id = p_config_id;
END LOOP;
FOR cur_result2 in cur2
LOOP
p_code := cur_result2.code;
CURSOR cur IS select a.config_id, a.code, a.creation_date, a.last_update_date from table_a a, table_b b where a.config_id = b.config_id and a.last_update_date > b.last_update_date;
CURSOR cur2 IS select * from table_a a where a.config_id not in (select config_id from table_b);
p_code number; p_creation_date date;
p_last_updat date;
p_config_id varchar2(32);
begin
FOR cur_result in cur
LOOP
p_code := cur_result.code;
p_creation_date := cur_result.creation_date;
p_last_updat := cur_result.last_update_date;
p_config_id := cur_result.config_id;
update table_b set code=p_code, creation_date=p_creation_date, last_update_date=p_last_updat where config_id = p_config_id;
END LOOP;
FOR cur_result2 in cur2
LOOP
p_code := cur_result2.code;