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.

What is Formula Column?

4 Answers  

---

What r the validation types?

3 Answers  

---

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,

---

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---

what is lexical parameter?

3 Answers   TCS,

---

what is the invoice matching

2 Answers  

---

in GL module specifing org_id or not?

1 Answers  

---

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  

---

While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,

---

What is the interface?

3 Answers  

---