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
- 5725 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 the use of constraints option in exp command.
What are the general rules on data consistency?
How to insert a record into a table?
What are the attributes that are found in a cursor?
What is the relation of a user account and a schema?
How to create a stored procedure in oracle?
How will you differentiate between varchar & varchar2?
Explain an integrity constrains?
What is translate in oracle?
What is the difference between translate and replace?
How to count duplicated values in a column in oracle?
Explain the use of compress option in exp command.
Explain compound trigger in oracle?
What is meant by joins?
What is the difference between formal parameters and actual parameters?
