Answer / kiran kumar

Triggers:
--------

1)Defined with create trigger
2)The data dictionary contains source code in the user_triggers.
3)Implicitly invoked
4)Commit, save point and rollback are not allowed(TCL)

Procedures:
-----------

1)Defined with create procedure
2)Data dictionary contains source code in user_source
3)Explicitly invoked
4)Those are allowed

Note: compare both ones with numbers mentioned..

Answer / suresh.somayajula

1. Triggers are implicitly invoked but

procedures are explicitly invoked.

2. in Triggers TCL commands are not allowed.

TCL commands are allowed in Procedures.

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

what is the invoice matching

2 Answers  

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

what are the types of interfacing?

3 Answers   TCS,

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

what are the important table names in purchasing?

3 Answers   TCS,

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

What is multi org?

6 Answers   Accenture, CTS,

---