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
What does fetching a cursor do?
What are different functions in sql?
How do I count duplicates in sql?
what is 'mysqld'? : Sql dba
What is the advantage of index in sql?
What are primary key and foreign key and how they work?
Differentiate pl/sql and sql?
What are pl sql procedures?
Which is better join or inner query?
What is meant by <> in sql?
How to write html code in pl sql?
Which function is used to return remainder in a division operator in sql?
When sql appeared?
What do you mean by dbms? What are its different types?
How many functions are there in sql?