create or replace procedure dddd
is
begin
update Cus_B a
set (a.col1,a.col2,....) = (select col1,col2,......
from Cus_A
where ID = a.ID);
--上面的Sql要求ID唯一
insert into Cus_B(col1,col2,....)
select col1,col2,.....
from Cus_A
where ID not in (select ID from Cus_B);end;
is
begin
update Cus_B a
set (a.col1,a.col2,....) = (select col1,col2,......
from Cus_A
where ID = a.ID);
--上面的Sql要求ID唯一
insert into Cus_B(col1,col2,....)
select col1,col2,.....
from Cus_A
where ID not in (select ID from Cus_B);end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货