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

When is the explicit cursor used ?

981

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

971

---

What is the difference between sql and t sql?

966

---

How to use transactions efficiently : transact sql

993

---

what is a materialized view? : Sql dba

999

---

Explain 3 basic parts of a trigger.

1257

---

What is a sql trace file?

979

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2414

---

What is multiple partition?

921

---

Why is sql important?

1027

---

Is ms sql traffic encrypted?

875

---

How many types of triggers exist in pl/sql?

1011

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1324

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

901

---

What program will open a mdb file?

915

---