what is instead of trigger. what is the use of that?
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 |
Tell me where we find the status of order information?
What are the requests groups?
Can functions be overloaded ?
How to attach the multiple templates in XML Pub Report?
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
in procedure how to return a value
Hoe to skip middle of the record by using SQL*Loader?
List the types of flexfield?
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
Explain what are the tables of auto invoice?