How many types of trigger can be used in a table at a time ?
- 7 Answers
- 10987 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 is a Text_io Package?
Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?
What is the difference between object embedding & linking in Oracle forms?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
Identify package function from the following ?
What built-in is used for changing the properties of the window dynamically?
What package procedure used for invoke sql plus from sql forms ?
What are modal windows?
can you change the default value of the radio button group at run time?
What is the use of Validation triggers in Reports?
how report can be generated if we have the database designed in oracle 10g?
What is the use of image_zoom built-in?
Oracle General 
