Categories
Uncategorized

Trigger (cIA 8)

Write an after statement-level trigger. Whenever an insert, update, or delete operation occurs on the EMP table, a row is added to the employee audit table recording the date, user, and action. create or replace trigger audit1_trigger after insert or delete or update on emp declare v_action varchar2(18); begin if inserting then v_action:=’added emp’; elsif […]