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.
DROP TRIGGER trigger_name;
trigger_name: The name of the trigger that you wish to delete or drop.
To show how to drop a using the DROP TRIGGER statement, use the following syntax:
DROP TRIGGER user_before_insert;