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 packages(if any) has oracle provided for use by developers?

5024

---

What's the procedure?

490

---

What is cursor status?

761

---

What is a behavioral trigger?

513

---

How do I partition in sql?

536

---

---

How do I access sql anywhere database?

495

---

How to run sql commands in sql*plus?

583

---

Explain what is a subquery ?

654

---

What is the command used to fetch the first 5 characters of a string?

704

---

Explain what is sql*plus?

668

---

What is anonymous block in sql?

638

---

How do I get sql certification?

526

---

Why are aggregate functions called so?

510

---

which types of join is used in sql widely? : Sql dba

537

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1152

---