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 local and global variables and their differences? : Sql dba
What is embedded sql in db2?
how would you get the current date in mysql? : Sql dba
What is the best sql course?
What is the difference between clustered and non-clustered indexes?
What is composite primary key in sql?
how to drop an existing table in mysql? : Sql dba
When is the update_statistics command used?
How do you copy a table in sql?
What is group by in sql?
What makes a good primary key?
What is autocommit sql?
How to pronounce postgresql?
How do I trace sql profiler?
Are null values same as that of zero or a blank space?