ORACLE关于merge into用法!MERGE INTO MSA2008BS.ATYW_ZS_GCZL AUSING (SELECT * fROM LOADTMP.MSA2008BS_ATYW_ZS_GCZL WHERE ETL_F IN ('I','D','A')) BON (A.ATZSCZLOID=B.ATZSCZLOID)WHEN MATCHED AND B.SHIPFID ='' THEN UPDATE SETA.SHIPFID =B.SHIPFID ,A.GCZ

来源：学生作业帮助网 编辑：作业帮 时间：2024/04/27 18:30:18

ORACLE关于merge into用法!MERGE INTO MSA2008BS.ATYW_ZS_GCZL AUSING (SELECT * fROM LOADTMP.MSA2008BS_ATYW_ZS_GCZL WHERE ETL_F IN ('I','D','A')) BON (A.ATZSCZLOID=B.ATZSCZLOID)WHEN MATCHED AND B.SHIPFID ='' THEN UPDATE SETA.SHIPFID =B.SHIPFID ,A.GCZ
ORACLE关于merge into用法!
MERGE INTO MSA2008BS.ATYW_ZS_GCZL A
USING (SELECT * fROM LOADTMP.MSA2008BS_ATYW_ZS_GCZL WHERE ETL_F IN ('I','D','A')) B
ON (A.ATZSCZLOID=B.ATZSCZLOID)
WHEN MATCHED AND B.SHIPFID ='' THEN UPDATE SET
A.SHIPFID =B.SHIPFID ,
A.GCZLDJZHM=B.GCZLDJZHM ,
A.CBDJH =B.CBDJH
WHEN NOT MATCHED THEN
INSERT(A.ATZSCZLOID,A.SHIPFID,A.GCZLDJZHM,A.CBDJH,A.CBCZR)
VALUES(B.ATZSCZLOID,B.SHIPFID,B.GCZLDJZHM,B.CBDJH,B.CBCZR)
;
中因为在WHEN MATCHED后加入了AND条件即：AND B.SHIPFID =''
之后报错,是不是oracle不支持WHEN MATCHED后跟条件呢?

ORACLE关于merge into用法!MERGE INTO MSA2008BS.ATYW_ZS_GCZL AUSING (SELECT * fROM LOADTMP.MSA2008BS_ATYW_ZS_GCZL WHERE ETL_F IN ('I','D','A')) BON (A.ATZSCZLOID=B.ATZSCZLOID)WHEN MATCHED AND B.SHIPFID ='' THEN UPDATE SETA.SHIPFID =B.SHIPFID ,A.GCZ
在when matched then 和 when not matched then 后面只能加insert() values 或者 update set .,. ,不能附加条件,而且then 后面的语句不能使用其他语句. 另外注意到,B的域只在using里面的查询有用吧 ,如果你要使用 也得是 在Using （） M 用m吧

WHERE只能跟在数据库对象之后，比如表和视图

qiyechao
说的很对，when matched then 和 when not matched then 后面只能加insert() values 或者 update set ，B的域只在using里面的查询有用，AND B.SHIPFID ='' 写在using里面,即
MERGE INTO MSA2008BS.ATYW_ZS_GCZL A
USING (SELE...

全部展开

qiyechao
说的很对，when matched then 和 when not matched then 后面只能加insert() values 或者 update set ，B的域只在using里面的查询有用，AND B.SHIPFID ='' 写在using里面,即
MERGE INTO MSA2008BS.ATYW_ZS_GCZL A
USING (SELECT * fROM LOADTMP.MSA2008BS_ATYW_ZS_GCZL WHERE ETL_F IN ('I','D','A') AND B.SHIPFID ='' ) B
ON (A.ATZSCZLOID=B.ATZSCZLOID)
WHEN MATCHED THEN UPDATE SET
A.SHIPFID =B.SHIPFID ,
A.GCZLDJZHM=B.GCZLDJZHM ,
A.CBDJH =B.CBDJH
WHEN NOT MATCHED THEN
INSERT(A.ATZSCZLOID,A.SHIPFID,A.GCZLDJZHM,A.CBDJH,A.CBCZR)
VALUES(B.ATZSCZLOID,B.SHIPFID,B.GCZLDJZHM,B.CBDJH,B.CBCZR)

收起

ORACLE关于merge into用法!MERGE INTO MSA2008BS.ATYW_ZS_GCZL AUSING (SELECT * fROM LOADTMP.MSA2008BS_ATYW_ZS_GCZL WHERE ETL_F IN ('I','D','A')) BON (A.ATZSCZLOID=B.ATZSCZLOID)WHEN MATCHED AND B.SHIPFID ='' THEN UPDATE SETA.SHIPFID =B.SHIPFID ,A.GCZ merge with和merge into区别 merge into / integrate into 的区别 Otherwise merge into the bike lane before making your turn.求翻译是关于驾驶的. merge Oracle Hint的用法 oracle中 between 用法 They decided to merge the two small companies into one 翻译成汉语 throw 用法关于throwing litter aboutthrowing litter into into the into the 最好有关于这个短语的句子,用法什么的... merge与fuse 有和不同merge 与fuse都有融合的意思,两者之间用法有差异吗?如有,能否结合例子说明? fit into的用法 flow into 的用法 made into 用法 research into 的用法 英语翻译Merge data from the original into the additional array at the very bottom stage,and thereafter perform the next merge from the additional into the original array,in which way merge operations are applied to the original and additional arr 关于 take into account的用法到底是 take sth. into account正确,还是 take into account sth.正确?请举例说明,谢谢! turned into 的意思&用法.