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 difference between null value, zero, and blank space?
Can we join two tables without common column?
How to create a menu in sqlplus or pl/sql?
Is it possible to create startup or shutdown trigger for on-schema?
Can sql developer connect to db2?
Which table is left in left join?
what is the difference difference between procedure and packages
2 Answers 3i Infotech, Oracle,
can i use dbms_output.put_line in a function u are telling as return statement
Define implicit and explicit cursors.
Explain what is table in a database?
What is database migration?
function can return value ,procedure also return value through out parameter then what is the difference?