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.

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

---

What are ad-hoc reports?

1 Answers  

---

what is the need of registering table in apps?

5 Answers   TCS,

---

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

---

Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,

---

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

What is responsibility and how u attach

5 Answers   Accenture,

---

FLEX FIELDS?

2 Answers  

---

What is Formula Column?

4 Answers  

---

What are do's and dont's of Interface?

0 Answers  

---

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

---

Tell me some errors names and number what u got while developing the reports?

1 Answers  

---