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
- 5724 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 I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
defination of bitmap index
query optmization techniques and quwry analyser+projects+ppts
What is the implicit cursor in oracle?
How to return top 5 rows in oracle?
What is tns service name?
Write a syntax for update query in oracle?
What is a parameter file in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the differences between blob and clob in oracle?
How many file formats are supported to export data?
How do you store pictures in a database?
State some uses of redo log files?
What do you understand by a database object?
How to create a new table in your schema?
