All Forums Database
tejasopalli 3 posts Joined 06/15
06 Oct 2015
updatting the table with multiple joins

UPDATE t1 r
SET r.c1 =
(SELECT
c.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.c7 >=c.c7(+)
r.c8 = c.c8(+)
AND rownum=1)
WHERE r.c1 IS NULL;
hi couldĀ  u please change this oracle code to terdata

teja sopalli
You must sign in to leave a comment.