Answer Posted / pranab kumar mishra
1.Saving the rext of the create package statement in two
different sql files facilitates latter modification to the
package.Each package is easily understood & interface
between package are simple,clear& well defined.
2.package promote code reuse through the use of library that
contain stored procedure & function.so redundent coding.
3.Hiding information.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What are types of indexes in sql?
What are sql indexes?
What is rename in sql?
what are numeric data types? : Sql dba
What is delimiter in pl sql?
How many types of keys are there in sql?
What is materialized view in sql?
Why indexing is needed?
Explain constraints in sql?
Why is a trigger used?
What are some emotional triggers?
What is the current version of sql?
How do I run a query in pl sql developer?
Is merge a dml statement?
What is clustered and nonclustered index in sql?
