Answer / Divya Sharma

In PL/SQL, an exception is an abnormal termination of a program. It occurs when a runtime error happens or when a condition occurs that requires the control to be transferred to an exception handler.

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

How do I install microsoft sql?

1 Answers  

---

Why stored procedures are faster than query?

1 Answers  

---

Is a secondary key the same as a foreign key?

1 Answers  

---

how to convert dates to character strings? : Sql dba

1 Answers  

---

What is the syntax to add a record to a table?

1 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

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

1 Answers   CTS,

---

How many triggers can be applied to a table?

1 Answers  

---

What is clustered index sql?

1 Answers  

---

Why do we use view in sql?

1 Answers  

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1 Answers  

---