用ssa表更新sor表的数据(用B更新A)
MERGE INTO SOR.PD_BOND_BASE A
USING SSA.PD_BOND_BASE S ON A.SEQ_ID=S.SEQ_ID AND A.BOND_CD=S.BOND_CD AND A.TXN_DT=S.TXN_DT AND S.ETL_FLAG IN('I','A')
WHEN MATCHED THEN
UPDATE SET xxx
WHEN NOT MATCHED THEN
INSERT xxx
用ssa表更新sor表的数据(用B更新A)
MERGE INTO SOR.PD_BOND_BASE A
USING SSA.PD_BOND_BASE S ON A.SEQ_ID=S.SEQ_ID AND A.BOND_CD=S.BOND_CD AND A.TXN_DT=S.TXN_DT AND S.ETL_FLAG IN('I','A')
WHEN MATCHED THEN
UPDATE SET xxx
WHEN NOT MATCHED THEN
INSERT xxx