Answer Posted / anilbabu makkena

It is on the based situation.
1st situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER Created.

1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fires.

2nd situation CONSTRAINT and AFTER STATEMENT Level TRIGGER
and AFTER ROW Level TRIGGER Created.

1.CONSTRAINT fires.
2.AFTER ROW Level TRIGGER Fires.
3.AFTER STATEMENT Level TRIGGER Fires.

3rd situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER and AFTER ROW Level TRIGGER and
AFTER STATEMENT Level TRIGGER Created.

1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fire.
4.AFTER ROW Level TRIGGER Fires.
5.AFTER STATEMENT Level TRIGGER Fires.

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4271

---

How do you remove duplicates without using distinct in sql?

973

---

What is the difference between distinct and unique in sql?

943

---

How can I speed up sql query?

958

---

What is difference between cursor and trigger?

1066

---

What is pl sql variable?

979

---

What is where clause in sql?

1033

---

What is a pdo connection?

1025

---

How to fix oracle error ora-00942: table or view does not exist

1010

---

Why do we need databases?

1036

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1068

---

What is dense_rank?

931

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

991

---

Can we use commit inside a trigger?

1080

---

Explain ttitle and btitle.

1116

---