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

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  

---

In oracle application how do you debug or trace errors?

0 Answers  

---

What is the interface?

3 Answers  

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

in procedure how to return a value

2 Answers   Wipro,

---

how can u find the status in po?

1 Answers  

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

what type of testing u r doing?

2 Answers   Convergys,

---

in ap_terms table what data will be stored

1 Answers  

---