what is the difference difference between procedure and
packages
- 2 Answers
- 9216 Views
- 3i Infotech, Oracle, I also Faced
- E-Mail Answers
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 does count (*) mean?
what is the syntax for using sql_variant_property? : Transact sql
Do we need to create index on primary key?
Explain exception handling in pl/sql?
how to create a new table in mysql? : Sql dba
What does 0 mean in sql?
explain the difference between bool, tinyint and bit. : Sql dba
how do you login to mysql using unix shell? : Sql dba
What are the query optimization techniques?
Can we join more than 2 tables in sql?
What is synchronized subquery?
How do I run a pl sql procedure in sql developer?
what is the difference between primary key and unique key? : Sql dba
What are sql procedures?
What is pl/sql table? Why is it used?
