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 clause?
Can we use update in sql function?
How do I send sql query results to excel?
What is a constraint?
what are myisam tables? : Sql dba
What is the difference between an inner join and an outer join?
Why we use stored procedure instead of query?
Does varchar need length?
How many indexes can be created on a table in sql?
Which is the correct statement about truncate and delete?
What are the string functions in sql?
What is pl sql block structure?
Which sql statement is used to delete data from a database?
What is rank function in sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql