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
- 5761 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 is the usage of control file in oracle?
How to use attributes of the implicit cursor in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What is an oracle user role?
Explain the use of owner option in exp command.
How to divide query output into groups in oracle?
How to store only time; not date and time?
Write a trigger example in oracle?
Explain joins in oracle?
What happens to the current transaction if a ddl statement is executed?
How many categories of data types?
Write a syntax for update query in oracle?
Why we use bulk collect in oracle?
What are the logical operations?
How to rename an index in oracle?
