Sometimes you might find that you are no longer require trigger on a table. In PL/SQL you delete or drop a trigger on a table using DROP TRIGGER statement.
PL/SQL Drop Trigger Syntax
Syntax
Where:
trigger_name: The name of the trigger that you wish to delete or drop.
PL/SQL Drop Trigger Example
To show how to drop a using the DROP TRIGGER statement, use the following syntax: