UPDATE t1 r
SET r.c1 =
FROM t2 c
WHERE r.c2 = c.c2(+) AND c.c3(+)='XX' AND c.c4(+)='XX' AND
r.c5 = c.c5(+) AND c.c6(+)='F'
r.c8 = c.c8(+)
WHERE r.c1 IS NULL;
hi could u please change this oracle code to terdata
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.