Reputation
Top tag
Next privilege 5 Rep.
Participate in meta
Badges
1
Impact
~408 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
24
awarded  Autobiographer
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