i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
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 |
Explain the importance of .pll extension in oracle?
What is an Oracle view?
How to retrieve 5th highest sal from emp table?
What is MTTR advisor in Oracle?
What is data file?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is SYSTEM tablespace and When is it Created?
waht is the difference between primary key and super key?
How to use "in" parameter properly?
What are the advantages of Views ?
What is catalog in Oracle?
How can we force the database to use the user specified rollback segment?