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
What is date functions?
Define SQL and state the differences between SQL and other conventional programming Languages?
What are the different types of sql commands?
What is the max nvarchar size?
What are the advantages of indexing?
What is trigger with example?
How to call shell script from pl sql procedure?
What is procedure function?
What is the use of pl/sql table?
How to use sql statements in pl/sql?
Is it possible for a table to have more than one foreign key?
What is execution plan in sql?
What is a recursive join sql?
What are the types of sql commands?
When are we going to use truncate and delete?
