Search code examples
oracle-databaseplsqlalterdatabase-trigger

How do I alter a trigger in Oracle?

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?

Solution

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

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