What is the Need of this concept

[Ralph]

I have just started by hands on triggering concepts in SQL.I wanted to know the need of database Triggers? Can someone brief me on this?

[Girish Tawry]

Triggers are used to have are reaction code for any action on the data of the table. i.e. if you want to have some code that has to be executed when ever there is an insert/update/delete on a table.

[siva sankar]

Hi,

Trigger is pl/sql block, which will excute automatically whenever an event occurs this is called trigger.
Types of triggers:
1.Data base triggers
2.Instead of trigger
3.session trigger

Database Trigger(table):
This trigger will fire table level only
before/after
Insert/update/delete
for each row/statement

Instead of trigger(view):
This trigger will fire view level only

If any queries please let me know.

Thanks,
Siva Sankar