Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to return an array from java to pl/sql?
What are the different types of sql commands?
what is the difference between group by and order by in sql? : Sql dba
What are different types of functions in sql?
What is the difference between view and stored procedure?
how tsql statements can be written and submitted to the database engine? : Transact sql
How do I truncate a sql log file?
What are pl/sql packages?
Is left join faster than join?
Which join is like an inner join?
When can we use the where clause and the having clause?
What are all ddl commands?
what's the difference between a primary key and a unique key? : Sql dba
Can we use insert statement in function?
What is the purpose of design view?
