How many types of trigger can be used in a table at a time ?
- 7 Answers
- 9841 Views
- I also Faced
- E-Mail Answers
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 does TKPROF stand for?
How to call Report from other Report ?
What are the default extensions of the files careated by forms modules?
List the editors availables in forms 4.0?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
how to pass 2 variables from one form to other form
Why oracle forms required?
What are the types of Pop-up window ?
all steps of bitmap report?
What is trigger associated with the timer?
What is a Check Box?
What is the built-in function used for finding the alert?
Oracle General 
