DROP TRIGGER in Oracle

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.

Please follow and like us:
Content Protection by DMCA.com