Answer Posted / khushal

The oracle table can have the 12 Trigger associated with it.

-- before constraints are applied

1) BEFORE INSERT STATEMENT LEVEL
2) BEFORE INSERT ROW LEVEL
3) BEFORE UPDATE STATEMENT LEVEL
4) BEFORE UPDATE ROW LEVEL
5) BEFORE DELETE STATEMENT LEVEL
6) BEFORE DELETE ROW LEVEL


7) AFTER INSERT STATEMENT LEVEL
8) AFTER INSERT ROW LEVEL
9) AFTER UPDATE STATEMENT LEVEL
10) AFTER UPDATE ROW LEVEL
11) AFTER DELETE STATEMENT LEVEL
12) AFTER DELETE ROW LEVEL

Respected sir, Please send me technical questions related to oracle apps..

1760

---

How to change program global area (pga) in oracle?

1031

---

What is the quickest way to export a table to a flat file?

918

---

how to join query for one source type is oracle another source type is sql server ?

2378

---

Explain about the analyze command in oracle?

996

---

What is meant by recursive hints in oracle?

1026

---

Explain what are the characteristics of data files?

1030

---

What is the difference between primary key and unique key and foreign key in oracle?

918

---

How to select an oracle system id (sid)?

1018

---

How to filter out duplications in the returning rows using oracle?

989

---

How to define a data source name (dsn) in odbc manager?

965

---

Why do we use coalesce function in oracle?

1051

---

What is parameterized cursor in oracle?

1065

---

What is tns entry?

1059

---

Explain overloading. Can functions be overloaded?

934

---