Interested to Buy Any Domain ? << Click Here >> for more details...
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
- 2 Answers
- 5640 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
What are joins, explain all types of joins?
Is there a function to split a string in plsql?
How to use existing values in update statements using oracle?
What are a collation and state the different types of collation sensitivity?
What is snapshot is too old? Give and example for better understand.
What is define in oracle?
How to sort output in descending order in oracle?
Please explain joins in oracle?
What is hot backup and logical backup?
How many memory layers are in the oracle shared pool?
What is the difference between sharding and partitioning?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to select some rows from a table in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
What is a nested table and how is it different from a normal table?
