i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
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
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How many types of database triggers exist?
What are the extensions used by oracle reports?
What is the quickest way to export a table to a flat file?
What is the difference between postgresql and oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
State and explain about oracle instance?
Explain an index segment?
What to do if the startbd.bat failed to start the xe instance?
How oracle handles dead locks?
What is user managed backup in Oracle?
How to write numeric literals in oracle?
Can multiple cursors being opened at the same time?
How to delete all rows a table in oracle?
How to loop through a cursor variable?