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
- 5639 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
Package is compiled once in the database and hence accessing
an object from a Package.procedure is more efficient than
Stored procedure as the object is Pinned to the DB unlike
the normal Stored procedure, again the core crux of the
project will make the choice.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
What are the built-in functions used for sending Parameters to forms ?
Describe the types of sub query?
what is IDE,DMV in sql server?
How to rename an index?
How to define a variable of a specific record type?
What is oracle latest version?
How to create a new table by selecting rows from another table?
Explain oracle’s server parameter file.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to use subqueries with the exists operator in oracle?
which clause we are not used in where clause?
What are transaction isolation levels supported by oracle?
Oracle General 
