PL/SQL Exception

PL/SQL Exception

PL/SQL Interview Questions

PL/SQL Interview Questions and Answers


PL/SQL Drop Trigger

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

PL/SQL Drop Trigger Syntax

Syntax

DROP TRIGGER trigger_name; 

Where:

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

PL/SQL Drop Trigger Example

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

DROP TRIGGER user_before_insert;