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 |
What is a Navigable item?
What is the use of image_zoom built-in?
What is 4-way match?
What are modalless windows?
Name of the functions used to get/set canvas properties?
how to create the triggers in the forms?
What is the order of the triggers fired once the form is opened?
What are the two types views available in the object navigator?
.fmb will be in which folder
What are the triggers associated with a check box?
What is the use of Validation triggers in Reports?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement