How do I alter a trigger in Oracle?

Question

I am trying to change the trigger script for my database. My trigger name is ARCH_USER_UPD_TRG and this puts any updates or deletes on the USER table into a Z_USER table

I am dropping a column from the USER table and now need to modify the trigger script to no longer use this column.

How do I modify the PL/SQL script of an oracle trigger?

Answer 1

A trigger is similar to a package or a procedure, so you can simply use

create or replace trigger triggerName
...
declare
...
begin
    ...
end;