TRIGGER: OLAPSYS.CWM$CLASSIFICATIONENTRYUPD

Source

Description

olapsys.cwm$classificationentryUPD
  before insert or update on olapsys.cwm$classificationentry 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.CreatedOn := SYSDATE;
      :new.CreatedBy := v_User_Name;
    else
      :new.LastModifiedOn := SYSDATE;
      :new.LastModifiedBy := v_User_Name;
    end if;
  end;