What are triggers?

Answers were Sorted based on User's Feedback



What are triggers?..

Answer / amit

Different types of triggers are:

Statement Level
Row Level
Before
After
INSTEAD OF (This can be used only on Views)

Triggers are mainly used to:

1. For audit purpose
2. For keeping track of particular action that would fire a
trigger.

Is This Answer Correct ?    5 Yes 0 No

What are triggers?..

Answer / suresh.somayajula

It's a pl/sql code or block that is executed on an

event in the database.

Is This Answer Correct ?    2 Yes 0 No

What are triggers?..

Answer / harwinder singh

triggers and named blocks in a RDBMS, that gets executed on
a particular operation such as insert,update or delete on
the table, with which they are associated

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

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

0 Answers   Accenture,


Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,


Can we customize a form with out template.fmb

5 Answers   Zensar,


what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,


what is meant by Table space?

2 Answers  






What do you understand by soa?

0 Answers  


how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,


What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,


What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,


what is meant by bind parameter?

2 Answers   Satyam,


what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,


what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,


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)