i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
- 2 Answers
- 5162 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 the attributes that are found in a cursor?
What are the logical operations?
What is a dynamic performance view in oracle?
Explain the use of parfile option in exp command.
How to recover a dropped table in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to resolve the ORA-39133 error in Oracle?
How to write numeric literals in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is null value in oracle?
What is a cursor in oracle?
Differentiate between translate and replace?
What is data type in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
How to bring a tablespace offline?
