Answer / Vipra Verma

An Instead Of Trigger fires before the SQL statement that would normally modify a table is executed, while an After Trigger fires immediately after the SQL statement is executed. An Instead Of Trigger can prevent the modification from occurring, whereas an After Trigger cannot stop it but can perform additional actions afterwards.

What is difference between inner join and cross join?

1 Answers  

---

How do you delete data from a table?

1 Answers  

---

What are sql indexes?

1 Answers  

---

what is self join and why is it required? : Sql dba

1 Answers  

---

How to get help at the sql prompt?

1 Answers  

---

What is before trigger?

1 Answers  

---

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

1 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

1 Answers  

---

How do you select unique values in sql?

1 Answers  

---

When can we use the where clause and the having clause?

1 Answers  

---

what is cross join? : Sql dba

1 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1 Answers  

---