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
- 5883 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 can I create database in oracle?
How to drop an index?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is procedure overloading in oracle?
How a database is related to tablespaces?
Use of an integrity constraint is better to validate data. Explain
How to do paging with oracle?
What is query image?
What is meant by raw datatype?
What is ceil and floor in oracle?
How to download oracle database 10g xe?
Difference between varchar and varchar2 data types?
Explain constraining triggers.
What is oracle open database communication (odbc)?
Can group functions be mixed with non-group selection fields?
