Answer Posted / mohit tyagi(siyana bulandshaha

Basically there are three types of triggers, but the way to
use is differ. it doesn't matter on which we are
implementing these trigger.
triggers are:-
1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

we can implement all these trigger on both module i.e
1.Application
2.Database

these both module are associate with the type of
implementation i.e.
1. Insert/delete/update
2. Before/After
3. Statement level/Row level

except this theory there are various ways to represent the
sql trigger. but all have the same concept for
implementation. so never confuse in order to represent the
sql trigger.

How subquery works in sql?

1067

---

How to call shell script from pl sql procedure?

1277

---

What is sql constant?

1034

---

how can we find the number of rows in a table using mysql? : Sql dba

1083

---

What is an inconsistent dependency?

1046

---

what are the different index configurations a table can have? : Sql dba

996

---

How exception is different from error?

1017

---

What is the file extension for sql database?

1000

---

what is sp_pkeys? : Transact sql

1158

---

What is sql trigger example?

1061

---

Can there be more than one function with a similar name in a pl/sql block?

985

---

How many tables can you join in sql?

957

---

Which one is faster ienumerable or iqueryable?

934

---

Can we create table in function?

964

---

What is the main difference between sql and pl/sql?

1094

---