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 |
did u received a single file or multiple files
Use the add_group_column function to add a column to record group that was created at a design time?
What is the built-in used for showing lov at runtime?
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
Can you change the color of the push button in design time?
What do we mean by record group in oracle forms?
Error_Code is a package proecdure ?
List the buil-in routine for controlling window during run-time?
What is a Trigger ?
How can you format a character field in a report Layout editor ?
what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item
What is a library?