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
- 5877 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
Explain integrity constraints?
What are the differences between number and binary_float in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
how to make an oracle object
How to get last row id?
Explain the use of tables option in exp command.
Explain the use of inctype option in exp command.
What happens to indexes if you drop a table?
Does oracle partitioning improve performance?
How to drop an index?
How to check the oracle tns settings?
How to create an oracle database?
What is a subquery in oracle?
What is the simplest tool to run commands on oracle servers?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
