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
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is java sql driver?
What does the base_object_type column shows in the user.triggers data dictionary view?
What are different types of triggers?
What is the difference between having and a where in sql?
What is dense_rank in sql?
What do you mean by “trigger” in sql?
Is it possible for a table to have more than one foreign key?
How do I partition in sql?
How many types of normalization are there?
Explain scalar functions in sql?
What is left inner join in sql?
What are the different types of joins in sql?
What are the qualities of 2nf?
Enlist the advantages of sql.