Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle Drop Trigger

Sometimes you might find that you are no longer require trigger on a table. In Oracle you delete or drop a trigger on a table using DROP TRIGGER statement.

Oracle Drop Trigger Syntax

Syntax

DROP TRIGGER trigger_name; 

Where:

trigger_name: The name of the trigger that you wish to delete or drop.

Oracle Drop Trigger Example

To show how to drop a using the DROP TRIGGER statement, use the following syntax:

DROP TRIGGER user_before_insert;