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 is the difference between distinct and unique in sql?
Mention what does the hierarchical profiler does?
how to create a table index in mysql? : Sql dba
What is loop in pl sql?
What is a primary key sql?
Where can I learn sql for free?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
When should I use nosql database?
what is 'mysqldump'? : Sql dba
Why do we use procedures in pl sql?
What is an exception in PL/SQL? What are the two types of exceptions?
How do I count rows in sql query?
Is sql similar to python?
How does one load ebcdic data? : aql loader
List different type of expressions with the example.