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
- 5760 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / kiran
Package is compiled once in the database and hence accessing
an object from a Package.procedure is more efficient than
Stored procedure as the object is Pinned to the DB unlike
the normal Stored procedure, again the core crux of the
project will make the choice.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you store pictures in a database?
candidate key is subset of super key but not vice-verse explain
What are the differences between blob and clob in oracle?
Where are the settings stored for each instance in oracle?
What are the restrictions on external table columns?
Why oracle is used?
Can you assign multiple query result rows to a variable?
What is the difference between Delete, Truncate and Drop in Oracle?
How to use "startup" command to start default instance?
What is the database name in oracle?
What operating systems are supported by oracle database 10g xe?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is a trace file and how is it created in oracle?
How to create a new table by selecting rows from another table?
How to use values from other tables in update statements using oracle?
