17,377
社区成员
发帖
与我相关
我的任务
分享
insert into TEST_AA a (AA_COL1,AA_AB_COL2,AA_AC_COL2)
select c.AC_COL1,b.AB_COL2,c.AC_COL2 from TEST_AC c,TEST_AB b where c.AC_COL1=b.AB_COL1(+)
insert into A (col1,col2)
select C.col1,C.col2
from C
where col1 = (select col1 from B);
insert into a (col1,col2)
select b.col1,c.col2
from b
where col1 = (select col1 from c);