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
- 5888 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
Can you tell me how to add new column in existing views?how?How is possible?
How do I start tns listener?
Where do you use decode and case statements?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How many types of auditing in Oracle?
How to display employee records who gets more salary than the average salary in the department?
How view is different from a table?
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 many anonymous blocks can be defined?
How to write numeric literals in oracle?
How to convert a string to a date in oracle database?
how to do daily transactions with out sql* loader control file regesterd in apps?
material view and view disadvantages?
Explain a segment?
How will you differentiate between varchar & varchar2?
