i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
- 2 Answers
- 5975 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 to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to use values from other tables in update statements using oracle?
How to start an oracle instance?
What is oracle latest version?
How to write a left outer join with the where clause in oracle?
