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 a database? : Sql dba
When can we use the where clause and the having clause?
Why use subqueries instead of joins?
What is sql and how does it work?
Do ddl statements need commit?
what is rollback? : Sql dba
What does where 1/2 mean in sql?
What is the difference between instead of trigger and after trigger?
When sql appeared?
What are different types of queries in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
How can get second highest salary in sql?
what are the disadvantages of mysql? : Sql dba
How can I get the number of records affected by a stored procedure?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?