Oracle DROP Trigger

In Oracle, DROP TRIGGER statement is used to drop the trigger if you find that you need to remove it from the database.

Syntax

snippet
DROP TRIGGER trigger_name;

Parameters

trigger_name: It specifies the name of the trigger that you want to drop.

Oracle DROP Trigger Example

It will drop the trigger name "SUPPLIERS_T1" from the table "SUPPLIERS".





Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +