what is instead of trigger. what is the use of that?
- 3 Answers
- 7255 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad reddy
Instead of trigger basically used to update the complex view.
Regards,
-Prasad.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / anu
Instead of trigger are used mainly in case of views.Suppose
we want to perform update in a table instead of inserting
data into that table.or to solve mutating table error we
used instead of trigger
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / suresh
All Views are updatable using Instead of Trigger
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the package?
wht is difference between is and as varibales,while declaring procedure which is better?
in procedure how to return a value
What is Place holder Columns?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
where the accounting related data is stored ? all type of accounting related data costing etc...
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
what are the match approvals in PO?
How to call oracle database stored procedure from form in form coding ?
What is multi org?
What is workflow?Explain with a example?
What does appl_top directory contain?
Oracle Apps Technical 
