what is the difference difference between procedure and
packages
Answer Posted / rajesh venati
A Procedure is a Named Pl/Sql program. Procedures are used
for to perform a particular task. Overloading concept is not
allowed in standard alone procedures.
Then go for Packages, package is grouping the collection of
database objects like procedures, functions, type, variable,
cursors and exception etc... Here overloading concept is
valid, we can define same name for database objects with
different type of parameters or data types.....
I believe this is useful.................
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are all types of user defined functions?
What is clause?
What is record variable?
What is pl sql and why it is used for?
What is difference between sql function and stored procedure?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is loop in pl sql?
Can we use pl sql in sql server?
what is table? : Sql dba
Are sql connections encrypted?
What is sql used for?
What are the different type of joins in sql?
Is sql scripting language?
What is user defined functions?
Difference between truncate, delete and drop commands?