What are triggers in database?

The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers gets executed. The event can be any of the Data Manipulation commands. In other words the event can be a insert, update or delete. Important aspect in a trigger for a programmer to create a trigger they must have the privilege for altering the table. It is also possible for a person to alter or modify a trigger owned by them or if they have the alter privilege on the trigger. These are the basic conceptys of triggers and there are many types of triggers available. To state a few are namely:



  • Row-Level Triggers

  • Statement-Level Triggers

  • Before Trigger

  • After Trigger

  • Schema Triggers

  • Database level Triggers

Questions by GeekAdmin   answers by GeekAdmin

Showing Answers 1 - 1 of 1 Answers

gvvskumaran

  • Jan 15th, 2007
 

Text description of cncpt076.gif follows

 trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures.

Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used.

 

Refer====>http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96524/c18trigs.htm#763

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions