oracle与sql 两表联系关系更新

oracle与sql 两表关联更新

所以加上collate Chinese_PRC_90_CI_AI

oracle 写法
update T_DestoryBillsDetail a set (wg02,oldwg10)=(select wg02,wg10 from gdgl b where a.wg00=b.wg00 and a.atype=b.atype ) where exists  (select 1 from gdgl b where b.wg00=a.wg00 and b.atype=a.atype) and a.bid=1211071407220801000