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 |
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
Can you change the color of the push button in design time?
What is the purpose of the product order option in the column property sheet?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad
List the built-in routines for the controlling canvas views during run-time?
did u received a single file or multiple files
What is system.coordination_operation?
Where is a procedure return in an external pl/sql library executed at the client or at the server?
What is the difference between system.current_field and system.cursor_field ?
what is place holder column
Which is the cheapest and quality Oracle Education provider in Bangladesh?