Modify and drop triggers

PL/SQL supports modifying and dropping triggers.

Modify a trigger

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

Typically, you can write the creation and modification of a trigger as follows:

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 a table is dropped, the triggers established on the table are also dropped.