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.

Why is there a need for sqlcode and sqlerrm variables?

1046

---

How do I view tables in mysql?

980

---

Can primary key be changed?

903

---

what is 'mysqladmin' in mysql? : Sql dba

1024

---

What is the syntax to add a record to a table?

1087

---

What is PL/SQL Records?

1181

---

What does seeding a database mean?

952

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

---

Can we use insert statement in function?

996

---

how to convert dates to character strings? : Sql dba

1164

---

What is t sql in sql server?

1067

---

Is natural join and inner join same?

919

---

What is the clause we need to add in function body to return variable?

1010

---

How to download oracle sql developer?

1096

---

How to run pl sql program in mysql?

1014

---