What are triggers?
Answers were Sorted based on User's Feedback
Answer / amit
Different types of triggers are:
Statement Level
Row Level
Before
After
INSTEAD OF (This can be used only on Views)
Triggers are mainly used to:
1. For audit purpose
2. For keeping track of particular action that would fire a
trigger.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / suresh.somayajula
It's a pl/sql code or block that is executed on an
event in the database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / harwinder singh
triggers and named blocks in a RDBMS, that gets executed on
a particular operation such as insert,update or delete on
the table, with which they are associated
| Is This Answer Correct ? | 1 Yes | 0 No |
what is difference between d2k report and oracle apps report
why r u move in the cus_top only why not move another top
is UOM maintained at master level or organization level or both?
we have select statement in that two exceptions that returns no value. In that which exception will raise?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
which parameters passed in report in oracle developer how to pass
oracle apps architecture
What are the different components of soa suite?
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
In custom.pll what are the events we can Not write.
What are the requests groups?
How relation will be made between modules in oracle financial?