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 is sql and its types?

0 Answers  

---

how to use in conditions? : Sql dba

0 Answers  

---

How to use sql*plus built-in timers?

0 Answers  

---

Why use truncate instead of delete?

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

---

Is t sql a programming language?

0 Answers  

---

how many values can the set function of mysql take? : Sql dba

0 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---