Answer / sanjeev verma

A Storeprocedure is a Set of transactionl SQL statements
which will do some operation. Storedprocedure is
precomplied . When we use sp's in our application it will
reduce network traffic because we need to just call the sp
from our appliaction by using the name of the sp and the
parameters, and no need of writing queries in the code.

A package is a collection of storedprocedures. A package
should have a declaration part and a body part. The
declaration part is used to declarte the stored procedures
and the body part is used to implement the storedprocedures.

What are the benefits of pl/sql packages?

0 Answers  

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

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

0 Answers   CTS,

---

Can we edit a view in sql?

0 Answers  

---

What is sql and explain its components?

0 Answers  

---

what is constraining table?

2 Answers  

---

What is a sql statement?

0 Answers  

---

What is linq to sql?

0 Answers  

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---

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

0 Answers  

---