i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
- 2 Answers
- 4751 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
How to define a variable of a specific record type?
What is an oracle cursor variable?
What is control file used for?
how do u setup a replication site?
What is enter substitution variable in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
What is set operator oracle?
What is bulk collect in oracle?
How to start a specific oracle instance?
11. Display the client number and name and the client number and name of the person who referred that client.
Explain how are indexes update?
How can I get column names from a table in oracle?
How to convert character types to numeric types?
How to drop a stored function?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
