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.

what is the difference between inner and outer join? Explain with example. : Sql dba

1061

---

how to enter numeric values as hex numbers? : Sql dba

1098

---

what is recursive stored procedure? : Sql dba

1026

---

What is a constraint?

1082

---

how to drop an existing table in mysql? : Sql dba

1088

---

How does sql*loader handles newline characters in a record? : aql loader

1089

---

What are all the different normalization?

1079

---

How to raise user-defined exception with custom sqlerrm ?

1178

---

What is the mutating table and constraining table?

1077

---

Explain scalar functions in sql?

1103

---

Can we use threading in pl/sql?

1089

---

What is the difference between database trigger and stored procedure?

1135

---

What is the use of non clustered index?

1042

---

How does sql store data?

957

---

Is left join and outer join same?

1114

---