How many types of trigger can be used in a table at a time ?
Answers were Sorted based on User's Feedback
u can define a trigger
1. For Each Row
2. For Each Statement
You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE
So it makes a total of 12.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / shanmugavelu
Max 12 types we can use before/after combination
| Is This Answer Correct ? | 8 Yes | 4 No |
Is it possible to attach same library to more than one form?
What is the use of Validation triggers in Reports?
What is an SQL FORMS ?
If a break order is set on a column would it effect columns which are under the column?
What are the built_ins used the display the LOV?
List the built-in routines for the controlling canvas views during run-time?
What are the important difference between property clause and visual attributes?
Can a property clause itself be based on a property clause?
When will ON-VALIDATE-FIELD trigger executed ?
What use of command line parameter cmd file?
What is a Non Query Record Group?
What are display items?