i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
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 create a new oracle data file?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
State all possible different index configurations a table can possibly have?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Calculate difference between 2 date / times in oracle sql?
How to connect to a local oracle 10g xe server?
How to connect asp pages to oracle servers?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Why do we need integrity constraints in a database?
How to drop a stored function?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How a tablespace is related to data files?
What are the oracle differences between nvl and coalesce