Name the different triggers associated with oracle forms having a master-detail relationship.
Answer / Bipin Bihari Chauhan
1. Before Master Form Trigger: Fires before the master form is loaded.
2. After Master Form Trigger: Fires after the master form has been loaded but before any detail form manipulations.
3. Before Detail Form Trigger: Fires before a new detail record is displayed or edited.
4. After Detail Form Trigger: Fires after a new detail record has been displayed or edited.
5. On Delete Trigger: Fires when a master record is deleted and all related detail records are to be deleted.
6. On Insert Trigger: Fires when a new master record is inserted and the related detail records need to be created.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can a button be used in a report to give a drill down facility?
List the Types of Items?
Why oracle forms required?
When does an on-lock trigger fire ?
What are the triggers available in the reports?
can i write commit in Before report trigger
What is the built-in used for showing lov at runtime?
suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?
Give the sequence of execution of the various report triggers?
Can you pass data parametrs to forms?
What are three panes that appear in the run time pl/sql interpreter?
how to pass 2 variables from one form to other form