create table a ( w varchar2(10) );create table b ( id varchar2(10), l1 varchar2(10), l2 varchar2(10), time date );create table c ( l3 varchar2(10), l4 varchar2(10) );create or replace precedure prc_insert ( @time in date ) is begin for r_1 in (select * from b where b.time = @time) loop delete from c where l3 = r_1.l1 and l4 = r_1.l2; insert into c values (r_1.l1,r_1.l2); end loop; commit; end;
(
w varchar2(10)
);create table b
(
id varchar2(10),
l1 varchar2(10),
l2 varchar2(10),
time date
);create table c
(
l3 varchar2(10),
l4 varchar2(10)
);create or replace precedure prc_insert
(
@time in date
)
is
begin
for r_1 in (select * from b where b.time = @time) loop
delete from c where l3 = r_1.l1 and l4 = r_1.l2;
insert into c values (r_1.l1,r_1.l2);
end loop;
commit;
end;