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.

Answer / suresh.somayajula

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

event in the database.

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

When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,

---

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  

---

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

2 Answers   Ranves IT Solutions, Scan Steel,

---

while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

How can you achieve loose coupling in soa framework?

0 Answers  

---

what is fiscalcalendar?

3 Answers   CTS,

---

Difference between triggers and procedures?

2 Answers  

---

can we write sql statement in Format trigger?

4 Answers  

---

what is the database size you used?

1 Answers   FIS,

---

How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,

---