Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between stored procedure and packaged
procedure
- 1 Answers
- 11523 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 are the parameter modes supported by pl/sql?
What does varchar include?
What do you mean by stored procedures?
How we can update the view?
What are instead of triggers?
How does one load ebcdic data? : aql loader
What is a null value?
What is the maximum number of columns in sql table?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is a primary key called that is made up of more than one field?
What is a table?
What are the types of queries in sql?
Why is theta join required?
What is cross join example?
Explain mutating table error.
