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 is scalar function?
What are sql commands?
What is a record in pl/sql?
Can we write dml inside a function in sql server?
How do I delete a trigger?
what is query cache in mysql? : Sql dba
Which is the correct statement about truncate and delete?
Does sql require a server?
What is AUTH_ID and AUTH_USER in pl/sql ?
What are properties of the transaction?
Do prepared statements prevent sql injection?
Who is the owner of mysql database?
What is rownum?
What is the function that is used to transfer a pl/sql table log to a database table?
What is exception? What are the types of exceptions?