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 to pronounce postgresql?
What are the popular database management systems in the it industry?
What are sql procedures?
What is package in pl sql with an examples?
What is the use of pl/sql table?
What does subquery mean in sql?
What is a table?
Are null values same as that of zero or a blank space?
How do I view tables in mysql?
can sql servers linked to other servers like oracle? : Sql dba
How do you delete data from a table?
what is dbms? : Sql dba
What is an invalid partition table?
What is nvarchar in sql?
What are pl/sql cursors?
