Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between stored procedure and packaged
procedure
- 1 Answers
- 11399 Views
- Google, Infosys, I also Faced
- E-Mail Answers
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 difference between sql and t sql?
What is scope and visibility in PL/SQL?
what are date and time data types? : Sql dba
What is $$ in sql?
How many tables can you join in sql?
What are the benefits of stored procedures?
How do I save the results of sql query in a file?
Is stored procedure faster than query?
Explain the working of foreign key?
how to check server status with 'mysqladmin'? : Sql dba
Sql technical questions
Why do we need cursor in pl sql?
How do you modify a column in sql?
What is program debugging?
What is dynamic sql in pl sql?
