Can I use merge on multiple conditions ORed or ANDed by several conditions. i tried doing the same but it throws the following error:- Statement run
merge into tt1 using tt2 on (tt1.c1=tt2.c1 and tt1.c2=tt2.c2 )
when matched then
update set c2=tt2.c2; Error received:
ORA-27432: step does not exist for chain.