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

What is oracle sql called?

506

---

How many row comparison operators are used while working with a subquery?

537

---

Why is there a need for sqlcode and sqlerrm variables?

587

---

Can we call dml statement in function?

542

---

How global cursor can be declare with dynamic trigger ?

1748

---

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

621

---

How is a PL/SQL code compiled?

670

---

what is data integrity? : Sql dba

596

---

How does a self join work?

520

---

What is a unique key and primary key and foreign key?

568

---

What is a function in oracle pl sql?

543

---

What are the different types of a subquery?

523

---

How to create a menu in sqlplus or pl/sql?

613

---

What are schema-level triggers?

582

---

What is package in pl sql?

579

---