Answer:
Create or replace trigger at_advisor
after delete or insert or update on advisor
for each row
Begin
if inserting
then
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'insert'
)
;
elsif deleting
then
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'delete'
)
;
else
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'update'
)
;
end if;
End;
Explanation:
as per above answer.
