Kiranmayi

• Jul 16th, 2005

 

A program in a database that gets called each time a row in a table is INSERTED, UPDATED, or DELETED. Triggers allow you to check that any changes are correct, or to fill in missing information before it is commited. Triggers are normally written in PL/SQL or Java

veena

 Profile Answers by veena 

• Sep 22nd, 2005

 

A Trigger is a PL/SQL block that executes whenever a particular event takes place.events in database like Insert,Update, Delete and combination of these three will cause the trigger to execute.Trigger is a technique to maintain integrity constraints

Susan

• Sep 24th, 2005

 

Trigger is an SQL procedure that initates an action when an event(inser/delete/update) occurs. They are stored and manageed by DBMS.A trigger cannot be called or executed:the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. Each trigger is attached to a single, specific table in the database.

nikhilbagde

 Profile Answers by nikhilbagde 

• Sep 10th, 2008

 

PL/SQL programming block that is executed implicity by data manipulation statement and trigger is perform event in database and application level.

Can be either :
Application Trigger : fired whenever an event occurs DML statement with particular application.

Database Trigger : fired whenever a data event (such as DML) or system event (such as logon on and shutdown) occurs on a schema or database

Regards
Nikhil Bagde
any query regarding pl/sql plz send ur que

yuvrajpape88

 Profile Answers by yuvrajpape88 

• Sep 12th, 2008

 

A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. Triggers can restrict access to specific data, perform logging, or audit data modifications.

samantha

• Apr 9th, 2013

 

The Event is performed and when the Condition is True The action is performed.................