Answer Posted / useroracle
Advantages of package:
-----------------------
A. Modularity
- Encapsulate related constructs.
B. Easier Application Design
- Code and compile specification and body separately.
C. Hiding Information
- Only the declarations in the pacakge specification
are visible and accessible to application.
- Private constructs in the package body are hidden
and inaccesible.
- All coding is hidden in the package body.
D. Added Functionality
- Persistency of variables and coursors.
E. Better Performance
- The entire package is loaded into memory when the
package is first referenced.
- There is only one copy in memory for all users.
- The dependency hierarchy is simplified.
F. Overloading
- Multiple subprograms of the same name.
| Is This Answer Correct ? | 55 Yes | 3 No |
Post New Answer View All Answers
Why do we use view in sql?
Write the command to remove all players named sachin from the players table.
What is the difference between inner join and outer join?
what are the advantages a stored procedure? : Sql dba
what are the differences among rownum, rank and dense_rank? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
Can we commit in trigger?
what are the nonstandard string types? : Sql dba
What is mutating table error?
What is graph sql?
how to concatenate two character strings? : Sql dba
How to get unique records from a table?
How do you go back in sql?
What's the procedure?
how many ways we can we find the current date using mysql? : Sql dba