Answer Posted / 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..

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2048

---

is it possible to run the interface without using oracle apps?

1978

---

What is the concept of soa governance?

1254

---

can we get profile values in report without using user exists is it possible how?

2884

---

Can we create tables in apps schema?

1143

---

What do you understand by soa and what are the benefits of using this architecture?

1087

---

Can you differentiate between mediator and osb?

1142

---

what is the differences between internal requisition and internal sales order?

2660

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2225

---

What is a flexfield? List out its types.

1171

---

please send me forms, xml pulisher questions,answers

2113

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1123

---

what is pay run id ?

2196

---

What are file in oracle.

2238

---

What do you understand by concurrent programs?

1101

---