what is instead of trigger in where u will use?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle soa suite and what are its different components?

643


Do you know what are user profiles in apps. Any examples you can give?

660


how to print multi lay outs,muti currency,muti language in xml publisher

10721


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

633


Explain oracle apps architecture.

761






how do you describe O2C along with tables

2309


What do you understand by soa and what are the benefits of using this architecture?

619


tell my any difficult situtation you solved in your experience in your company?

1866


what is pay run id ?

1706


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2126


How can a process be deployed in soa?

692


can we use look up type instead of a pofile option?or valueset?is it possible how?

1783


What are the different components of soa suite?

721


what is the difference between request group and request security in oracle apps?

5046


What do you understand by soa?

689