Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


CREATE OR REPLACE TRIGGER SET_LAST_UPDATED_ACCOUNTS
BEFORE INSERT OR UPDATE
ON ACCOUNTS
FOR EACH ROW
DECLARE
BEGIN
:new.LAST_UPDATED := sysdate;
END;


CREATE OR REPLACE TRIGGER SETTRIGGER SET_LAST_UPDATED_ACCOUNTACC_PORTFOLIOPORTF
BEFORE INSERT OR UPDATE
ON ACCOUNT_PORTFOLIO
FOR EACH ROW
DECLARE
BEGIN
:new.LAST_UPDATED := sysdate;
END;

...