i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
- 2 Answers
- 4761 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / suresh babu
The procedure,which we defined with in package,will be very
powerful,once we call the package it will load all
procedures and functions dynamically.so we can access more
number of procedures with out calling again and again.
But we can't call multiple procedures in single time.If we
want to access multiple procedures,which we didn't defined
with in package,isn't possible.we can call those procedures
one by one.
So the procedure,which we defined with in package, is very
powerful than the procedure,which we didn't defined with in
package.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain the use of owner option in exp command.
What are the advantages of oracle?
What is a snapshot log?
query optmization techniques and quwry analyser+projects+ppts
What is oracle rowcount?
types of indexes and the rationale behind choosing a particular index for a situation.
How to get the Installed Oracle Version Information ?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between "as" and "is" in an oracle stored procedure?
How to use in conditions in oracle?
What are oracle functions?
How to export your own schema?
What are the general rules on data consistency?
What is difference between cartesian join and cross join?
List out the difference between commit, rollback, and savepoint?
