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 are sql*plus environment variables?

1087

---

Can we commit in trigger?

959

---

What is a sql profiler?

1010

---

Does truncate require commit?

959

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1031

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

975

---

How to run sql*plus commands in sql developer?

1143

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2180

---

Why do we use sqlite?

962

---

Can a key be both primary and foreign?

986

---

What is bulk compiling in pl/sql.?

1121

---

how to check myisam tables for errors? : Sql dba

1314

---

What is normalization sql?

1049

---

What is a left inner join?

1009

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1100

---