what is the difference difference between procedure and
packages
- 2 Answers
- 9634 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 is the purpose of using pl/sql?
Can a select statement fire a trigger?
What is a pl/sql block?
Which join is like inner join?
What is the basic form of sql query?
Where do we use pl sql?
what is cross join? : Sql dba
Are sql database names case sensitive?
Are dml statements autocommit?
How does sql*loader handles newline characters in a record? : aql loader
Explian rowid, rownum? What are the psoducolumns we have?
What are different types of statements supported by sql?
How many unique keys can a table have?
What is trigger and types?
What is the main difference between sql and pl/sql?
