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
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What does pl sql stand for?
What are records give examples?
What is the non-clustered index in sql?
What are all different types of collation sensitivity?
What are the key differences between SQL and PL SQL?
Mention what does the hierarchical profiler does?
What is the difference between a primary key and a clustered index?
What does over partition by mean in sql?
what are integrity rules?
What is execution plan in sql?
What is data type in database?
What is the purpose of the partition table?
What is a delimiter in sas?
what is the difference between cluster and non cluster index? : Sql dba