This Oracle tutorial explains how to use the DROP TRIGGER assertion to drop a set off in Oracle with syntax and examples.
Once you have created a trigger in Oracle, you would possibly discover that you want to put off it from the database. You can do this with the DROP TRIGGER statement.
The syntax to a drop a trigger in Oracle in Oracle/PLSQL is:
DROP TRIGGER trigger_name;
Parameters or Arguments
trigger_name The identify of the set off that you desire to drop.
See additionally how to create AFTER DELETE, AFTER INSERT, AFTER UPDATE, BEFORE DELETE, BEFORE INSERT, and BEFORE UPDATE triggers.
Let’s seem to be at an example of how to drop a trigger in Oracle.
DROP TRIGGER orders_before_insert;
This example uses the ALTER TRIGGER declaration to drop the trigger called orders_before_insert.