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
How do I create a sql database?
What is sql resultset?
which types of join is used in sql widely? : Sql dba
How many tables can you join in sql?
What do you mean by “trigger” in sql?
how to include numeric values in sql statements? : Sql dba
How many joins in sql?
How many types of triggers exist in pl/sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Can a view be mutating? If yes, then how?
How to test for null values?
Why does sql need a server?
Which is better cte or subquery?
What is aggregate function in sql?
Enlist some predefined exceptions?