Thursday 5 December 2013

What is trigger?

A Database Trigger is a stored procedure that is fired when a DML operation is performed on the table. In total there are 13 types of Triggers

Syntax for creating a trigger:
            CREATE OR REPLACE TRIGGER <TRIGGERNAME> before / after
                        [INSERT / UPDATE / DELTE ] ON <TABLE NAME>
                        {For each Statement / Row}
                        {When <condition…..>}

No comments:

Post a Comment