TRIGGER: SCOTT.AFTER_INS_UPD_ON_EMP

Source

Description

scott.after_ins_upd_on_emp
before insert or update
on scott.emp
for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
   :new.ename := upper(:new.ename);
end;