Answer Posted / madhavi
The main advantage of package is one time compilation
process.while the first time of compilation the source code
is converted into P-code and stored in the database so that
for n no of time calling the pckg it does not take any
memory locations...
*Then whatevere the database objects declared in the
package specification will be globally accessible.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
Does mysql support pl sql?
How is debugging done?
What are crud methods?
how to get @@error and @@rowcount at the same time? : Sql dba
How can we find duplicate records in a table?
what is the difference difference between procedure and packages
How to add new employee details in an employee_details table with the following details
What is composite data type in pl sql?
What is the difference between drop and truncate commands?
What is the use of & in pl sql?
When is the update_statistics command used?
How do you run a query?
What are sql procedures?
What are literals in sql server?
Explain the working of primary key?