CodesJava

Easy learning with example program codes

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:
error









Copyright © 2019 CodesJava DMCA.com Protection Status