what is the difference between stored procedure and packaged
procedure
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.
Is This Answer Correct ? | 9 Yes | 4 No |
What is the plv (pl/vision) package offers?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
How do you modify a table in sql?
What is using in sql?
what is data integrity
How delete all records from table in sql?
how do you control the max size of a heap table? : Sql dba
explain what is mysql? : Sql dba
How do I start sql profiler?
What are the types of variables use in pl sql?
Is foreign key mandatory?
Is sql pronounced sequel or sql?