Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of trigger can be used in a table at a time ?
- 7 Answers
- 12167 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 are bind variables?
What are the types of visual attribute settings?
What is a master detail relationship?
What is an Invoice ? How many types of invoices are there in AP and AR ?
What are the menu items that oracle forms 4.0 supports?
Explain about horizontal, Vertical tool bar canvas views?
what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?
What are the Coordination Properties in a Master-Detail relationship?
can i use lexical variable in formula column
How can I message to passed to the user from reports?
Can a repeating frame be careated without a data group as a base?
What is the difference between $$DATE$$ & $$DBDATE$$
Oracle General 
