rahultripathi

 Profile Answers by rahultripathi 

• Sep 21st, 2005

 

Trigger are storege procedure that database should take action when relavent event occur

  In other word we can say trigger are stor procedure that fire when the relavent event occure such as insetion , deletion,updation ,deletion.  

ajay sharma

• Oct 13th, 2005

 

Trigger is a named PL/SQL block which is executed automaticaly when certain DML actions like INSERT,UPDATE, DELETE etc takes place in the table for which trigger is written.

Prasad Meduri

• Feb 13th, 2006

 

Hi,

Database Trigger is a pl-sql block which would fire whenever certain DML operation happens on the database.

Implicit and explicit triggers are available.

Implicitly fired pl-sql blocks are called Implicit triggers

otherhand we can write our own triggers which will come under explicit category.

We can write trigger(s) for <BEFORE/AFTER> <INSERT/UPDATE/DELETE> ON <TABLE_NAME>

CREATE TRIGGER TRIG BEFORE UPDATE ON EMP AS

..........................

...........................

END TRIG;

So we have 6 classification(s).

Apart from this we have INSTEADOF <BEFORE/AFTER> <INSERT/UPDATE/DELETE>

please try..

TGR

• Nov 1st, 2007

 

Trigger is stored procedure that is invoked automatically when a predefined event occurs.
like:-INSERT,UPDATE,DELETE.

A trigger is like an event procedure that runs when data changes

sreyas kvm

 Profile Answers by sreyas kvm Questions by sreyas kvm

• Feb 3rd, 2008

 

Trigger is a self executing event in sql server where a relevent action is occured.

triggers are useful in master-child relation ship in a table.

Trigger can be created as,

create trigger triggername on tablename for insert,update,delete as "necessory action"

neel_desai

 Profile Answers by neel_desai 

• Oct 11th, 2008

 

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.

There are three types of triggers:
1. DML trigger
                           DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.

2. DDL trigger
                           DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations.

3. Logon trigger
                           Logon triggers fire in response to the LOGON event that is raised when a user sessions is being established.

Please Note:
-DML triggers fire when any valid event is fired, regardless of whether or not any table rows are affected.
-Code inside triggers will run under escalated privileges.