Modify and drop triggers

PL/SQL supports modifying and dropping triggers.

Modify a trigger

Currently, you can use the REPLACE TRIGGER statement in DDL statements to modify a trigger.

Typically, you can use the following statement to create or modify a trigger:

CREATE OR REPLACE TRIGGER trigger_name ...

If the trigger_name does not exist, a trigger is created. If the trigger_name already exists, the trigger is modified.

Drop a trigger

You can use the DROP TRIGGER statement to drop a trigger. The syntax is as follows:

DROP TRIGGER trigger_name;

In addition, when you drop a table, the triggers established on the table are also dropped.