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 can I use instead of union in sql?

0 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

how can i read write files from pl/sql

3 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

Is full outer join same as cross join?

0 Answers  

---

What does count (*) mean in sql?

0 Answers  

---

What is posting?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

What are the built in functions of sql?

0 Answers  

---

What is a column in a table?

0 Answers  

---