在Update后面加個where條件UPDATE aaa a SET (val,demo) = (SELECT val,demo FROM bbb WHERE id = a.id) where a.id in (select distinct id from bbb)
to :yqwd911(windy)UPDATE aaa a SET (val,demo) = (SELECT val,demo FROM bbb WHERE id = a.id) where a.id in (select distinct id from bbb)你的语句我也用过,得到的是1 100 AAA 2 BBB 3 CCC 4 4 D 5 5 E 6 6 F2,3行的null 没变为0.
試試這個 UPDATE aaa a SET (val,demo) = (SELECT nvl(val,0),demo FROM bbb WHERE id = a.id) where a.id in (select distinct id from bbb)
UPDATE aaa a SET (val,demo) = (SELECT val,demo FROM bbb WHERE id = a.id) where exists(select 1 from bbb where id=a.id);
职位描述:
专业背景要求:
1、计算机软件、应用数学、电力等相关专业毕业;
2、熟悉面向对象技术、ASP.NET开发;
3、熟悉Oracle数据库操作与开发;
4、具备很好的团队合作精神,能够承受工作压力且能够长期出差;
5、有石油行业应用开发经验者优先考虑;
6、至少1-2年相关工作经验; 联系方式:[email protected] 李先生
SET (val,demo) = (SELECT val,demo FROM bbb WHERE id = a.id)
where a.id in (select distinct id from bbb)
SET (val,demo) = (SELECT val,demo FROM bbb WHERE id = a.id)
where a.id in (select distinct id from bbb)你的语句我也用过,得到的是1 100 AAA
2 BBB
3 CCC
4 4 D
5 5 E
6 6 F2,3行的null 没变为0.
UPDATE aaa a
SET (val,demo) = (SELECT nvl(val,0),demo FROM bbb WHERE id = a.id)
where a.id in (select distinct id from bbb)
SET (val,demo) = (SELECT val,demo FROM bbb WHERE id = a.id)
where exists(select 1 from bbb where id=a.id);