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
What is foreign key in sql with example?
What are %type and %rowtype for?
what is a composite key ? : Sql dba
How do I edit a trigger in sql developer?
how would concatenate strings in mysql? : Sql dba
How do you optimize a query?
Is join and inner join the same?
When are we going to use truncate and delete?
What is the sql*loader? : aql loader
What is nosql db?
Difference between truncate, delete and drop commands?
what is foreign key? : Sql dba
What are string functions in sql?
What is the difference between left and left outer join?
Is drop table faster than truncate?
