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?

[ALTER TRIGGER](https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4001.htm) — Juan Carlos Oropeza, Sep 20 '16 at 13:28

score 12 · Accepted Answer · answered Sep 20 '16 at 13:25

12

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

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

answered Sep 20 '16 at 13:25

Aleksej

22,443
5
33
38

Rahul · Answer 2 · 2016-09-20T13:30:02.720

3

The easy solution would be to Drop and Create the trigger once again with the modified SQL script code.

DROP TRIGGER ARCH_USER_UPD_TRG; 

CREATE TRIGGER ARCH_USER_UPD_TRG
//rest of code body

edited Sep 20 '16 at 13:30

answered Sep 20 '16 at 13:24

Rahul

76,197
13
71
125

1

There is no need to drop and recreate, you can simply do "create or replace" – Andrew Brennan Sep 20 '16 at 14:04

How do I alter a trigger in Oracle?

2 Answers2