1 reputation
bio website
location
age
visits member for 1 year
seen Mar 30 '13 at 10:15

Microelectronic engineer in an earlier avatar turned Software Developer


Mar
28
comment Oracle trigger to update columns daily
Thank you David. I had misunderstood triggers. Now wondering if I can handle it with just triggers instead of scheduling. CREATE OR REPLACE TRIGGER triggerName BEFORE UPDATE ON tableA FOR EACH ROW BEGIN :new.date1 = :old.date1 :new.date2 = :old.date2 :new.date3 = :old.date3 WHERE primarykey IN (1,2,3,4,5,6,7,8,9) AND status!='cancelled' END Will this work for my case?
Mar
28
asked Oracle trigger to update columns daily