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
Define sql delete statement.
what's the difference between a primary key and a unique key? : Sql dba
Why schema is used in sql?
What packages(if any) has oracle provided for use by developers?
how to escape special characters in sql statements? : Sql dba
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is the difference between an inner join and an outer join?
Which join is like inner join?
Why use subqueries instead of joins?
what are the types of subquery? : Sql dba
Explain the difference between drop and truncate commands in sql?
What is materialized view in sql?
Which join is like an inner join?
Which is faster joins or subqueries?
What is sql lookup?
