Answer Posted / rajesh
* 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 ? | 11 Yes | 0 No |
Post New Answer View All Answers
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How to take user input in pl sql?
What is #table in sql?
What are stored procedures in mysql?
What is the difference between in and between in sql?
how to select first 5 records from a table? : Sql dba
Is sql the best database?
what is datawarehouse? : Sql dba
Difference between truncate, delete and drop commands?
what are date and time intervals? : Sql dba
Write a query to display the current date in sql?
What is sqlca in db2?
What is sql performance tuning?
how would concatenate strings in mysql? : Sql dba
Is natural join and inner join same?