Answer Posted / robert son das

There are total four(4) types of triggers..

they are:
before insert----row level
before delete--row level
before update--row level

before insert----statement level
before delete--statement level
before update--statement level

after insert----row level
after delete--row level
after update--row level

after insert----statement level
after delete--statement level
after update--statement level

instead of trigger--row level
instead of trigger--statement level

Which is better trigger or stored procedure?

946

---

What are the different ways to optimize a sql query?

944

---

What is the difference between pl and sql?

1090

---

What is column?

983

---

Can cursors be part of a trigger body?

1636

---

Is it possible to update views?

954

---

How do you add a column to a table?

1050

---

What is the difference between database trigger and stored procedure?

1069

---

What is pl sql block structure?

1034

---

What are tables and fields in the database?

1104

---

What do you understand by exception handling in pl/sql?

1031

---

What is the difference between unique and primary key constraints?

1066

---

What is the sql query to display the current date?

1041

---

Is natural join same as inner join?

928

---

What does (+) mean in sql joins?

1059

---