17,377
社区成员
发帖
与我相关
我的任务
分享
create table TblA(ColA NUMBER PRIMARY KEY, ColB VARCHAR2(30));
create table TblB(ColA NUMBER PRIMARY KEY, ColB VARCHAR2(30));
insert into TblA
select * from TblB b where b.cola not in(select a.cola from TblA a group by a.cola)
update TblA a Set (a.ColB) =(select b.Colb from TblB b where a.cola=b.cola)
create table TblA(ColA NUMBER PRIMARY KEY, ColB VARCHAR2(30));
create table TblB(ColA NUMBER PRIMARY KEY, ColB VARCHAR2(30));
insert into TblA
select * from TblB b where b.cola not in(select a.cola from TblA a group by a.cola)
update TblA a Set (a.ColB) =(select b.Colb from TblB b where a.cola=b.cola)