Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is instead of trigger in where u will use?

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

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,


In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,


wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,


Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  


what is global tempory table?

1 Answers   BirlaSoft,


What is ment by Global Templates in Oracle.

1 Answers   IBM,


in ap_terms table what data will be stored

2 Answers   Wipro,


Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,


what is mutating table and mutating error and how to solve that?

3 Answers  


which parameters passed in report in oracle developer how to pass

3 Answers  


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

0 Answers  


what are the match approvals in PO?

3 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)