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
- 5772 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
How does oracle handle read consistency?
How to convert csv to table in oracle?
What is an index associated with a constraint?
What is the difference between I and G in Oracle?
What are the uses of linked server and explain it in detail?
Can a formula column referred to columns in higher group ?
Query to retrieve record for a many to many relationship ?
How do I uninstall oracle client from windows?
What is a dead lock in oracle?
What is a synonym? What are its various types?
How to login to the server without an instance?
What is connection pool in oracle?
Is postgres faster than oracle?
How to connect to the server with user account: sys?
What is the difference between Delete, Truncate and Drop in Oracle?
