what is instead of trigger in where u will use?

Question Posted / rameshmcaou

2 Answers
8072 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is instead of trigger in where u will use?..

Answer / sidharth

The primary advantage of INSTEAD OF triggers is that they
allow views that would not be updatable support updates. A
view comprising multiple base tables must use an INSTEAD OF
trigger to support inserts, updates and deletes that
reference data in the tables. Another advantage of INSTEAD
OF triggers is that they allow you to code logic that can
reject parts of a batch while allowing other parts of a
batch succeed.

Is This Answer Correct ?

6 Yes

0 No

what is instead of trigger in where u will use?..

Answer / krishh

Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.

Hope u get it.....
Cheers !!!

Is This Answer Correct ?

5 Yes

7 No

Post New Answer

More Oracle Apps Technical Interview Questions

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers Wipro,

what is the prerequisite for defining unit of measure?

1 Answers Scan Steel, TCS,

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers

Tell me where we find the status of order information?

0 Answers

wht r the basetables of customer interface?

2 Answers

can we use anchor propery in XML reports?if yes?explain?

2 Answers Oracle,

can we get profile values in report without using user exists is it possible how?