what is the difference difference between procedure and
packages
Answer Posted / kanchan kumari
procedure is named pl/sql block which is used by
programmer to perform any task these type of block exist in
database physically.
package is also named pl/sql block which is associated
with pl/sql variable, view, sub programs.
package can't be invoked
in other word we can say that package can contain more than
one procedure, function etc.but procedure can't
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the maximum number of columns in sql table?
How can you know that statistics should be updated?
Why do you partition data?
Does sql full backup truncate logs?
Can you selectively load only those records that you need? : aql loader
What is an inner join sql?
What are the two types of cursors in pl sql?
What is pivot in sql?
Why is pl sql needed?
Is sqlexception checked or unchecked?
What is application trigger?
Is sql between inclusive?
What is the use of index in hive?
Can we insert in sql function?
what does it mean to have quoted_identifier on? : Sql dba