TYpes of Trigger

[sammy]

What are the types of trigger available in Oracle. Can someone brief me on this.

[nnirmalkumar]

hi,

There r 12 types of trigger which can be applied to a table. + Another one more trigger also called instead of trigger which is used to update views.

Types of trigger:

After/Before

for insert/update/delete
look in for oracle online for full details with examples.

cheers
Nirmal