Answer Posted / nilesh

There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS

Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE

and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)

ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

What is sap sql?

938

---

What is the best sql course?

945

---

How insert into statements in sql?

1019

---

What is the difference between mdf and ndf files?

1074

---

Can we use ddl statements in stored procedure sql server?

975

---

How to handle bulk data?

1274

---

Differentiate between pl/sql and sql?

1087

---

what is a unique key ? : Sql dba

1046

---

Define select, insert, create, delete, update, drop keywords

1003

---

How do you declare a constant?

918

---

How do I save the results of sql query in a file?

939

---

What does the sign mean in sql?

932

---

Can a varchar be a primary key?

966

---

How to set up sql*plus output format in oracle?

983

---

What is Collation Sensitivity ? What are the various type ?

916

---