ORACLE DROP TRIGGER
As the name itself suggests, the Oracle database will fire this trigger to drop a trigger or in simple words the Oracle DROP Trigger is used to remove an already existing trigger from the database.
Syntax:
DROP TRIGGER trigger_name;
Parameters:
trigger_name: It is used to specify the name of the trigger to be created.
Example:
DROP TRIGGER STUDENTS_T; |
Explanation:
The STUDENTS_T is an already existing trigger in the Oracle database which will be removed after the execution of the above query.