Update using where clause 1

[anniez]

Can you help me write the update statement:

UPDATE TABLE1
SET FIELD1=:NEW.FIELD1,
FIELD2=:NEW.FIELD2,
WHERE TABLE1.EMPID=:NEW.EMPID

to also update table1.curstat to 1 if :new.reason=2,
table1.curstat to 2 if :new.reason=4,
table1.curstat to 3 if :new.reason is null

I can't seem to get the right syntax. Thanks

 

[sem]

You may use DECODE function:

update table1 set curstat decodenew.reason,2,1,4,2,null,3)
Regards, Dima

 

[anniez]

Is there a way to give this response 10 red stars?
Thank you so much -