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 delete and truncate statement in sql?
What is the purpose of design view?
What are the different datatypes available in PL/SQL?
Explain aggregate functions are available there in sql?
what are all the different normalizations? : Sql dba
what will be the output: select 1 from emp union all select 2 from emp;
what are the features and advantages of object-oriented programming? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is pls_integer in pl sql?
How to trace the errors in pl/sql block code?
How do you go back in sql?