what is the difference between stored procedure and packaged
procedure
Answer Posted / 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.
Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is the full form of sql?
What are the two different parts of the pl/sql packages?
What is schema in sql example?
What is insert command in sql?
What is the difference between a subquery and a join?
How show all rows in sql?
What are triggers in sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is a field in a database?
Can you inner join the same table?
What is pragma in pl sql?
define data blocks ? : Sql dba
How do you modify a column in sql?
what is user defined functions? : Sql dba
What is numeric function sql?