TRIGGER: OLAPSYS.CWM2$LEVELUPD

Source

Description

olapsys.CwM2$LevelUPD
  before insert or update on olapsys.CwM2$Level for each row
  

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
    v_User_Name varchar2(30);
  begin
    select USER into v_User_Name from dual;
    if inserting then
      :new.CreatedDate := SYSDATE;
      :new.UpdatedDate := null;
    else
      :new.UpdatedDate := SYSDATE;
    end if;
    :new.LastChangeUser := v_User_Name;
  end;