Resolved: create trigger for IF condition in oracle

Question:

I have created a trigger which inserts City as Others for all the data inserted with City name OTHERS
But it updates as null for text other than OTHERS. So I want to add IF condition for the same. Below is my trigger.

create or replace TRIGGER TGR_UPD_OTHERS_TVIPL
   BEFORE INSERT OR UPDATE ON IPCOLO_IPFEE_CALC_MST
FOR EACH ROW
 BEGIN
     new.CITY := case :NEW.CITY
                     when 'OTHERS' THEN 'Others'
                     end;
END;

Answer:

That’s because you didn’t say what to do “else”:

:new.city := case when :new.city = 'OTHERS' then 'Others'
                  else :new.city
             end;

If you have better answer, please add a comment about this, thank you!

Resolved: create trigger for IF condition in oracle

Resolved: Vaadin 14.9 – Redirect on Session Destroy Event

Resolved: How to separate multiple answers in one column, for multiple columns, by creating extra columns

Resolved: How to set consistent decimal separators in R data frame?

Leave A Reply