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 are date and time functions in mysql? : Sql dba
Is natural join and inner join same?
How to rename a table?
How to select 10 records from a table?
What are character functions in sql?
what are integrity rules?
How can I speed up sql query?
Which join condition can be specified using on clause?
What are sql procedures?
What is a scalar value in sql?
What is native sql query?
What does the hierarchical profiler does?
What are the differences between implicit and explicit cursors?
What is meant by user defined function?
How to select random rows from a table?