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
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is synonyms?
what is table? : Sql dba
What are actual parameters and formal parameters?
Can a view be mutating? If yes, then how?
Is sql procedural language?
What does t sql mean?
How to prepare for oracle pl sql certification?
What does varchar include?
How do you pronounce sql?
What are literals in sql server?
Is primary key always clustered index?
what happens if you no create privilege in a database? : Sql dba
What are data types in pl sql?
What is sql and its types?