Answer Posted / glibwaresoftsolutions
Using PL/SQL packages offers several benefits, including:
• Encapsulation: You can encapsulate related code and data within a package, promoting modular and organized code.
• Reusability: Packages allow you to reuse code across multiple programs and reduce redundancy.
• Information Hiding: You can hide implementation details by exposing only the necessary interfaces in the package specification.
• Improved Performance: Packages are precompiled and stored in the database, which can enhance performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the three pl sql block types?
What plvcmt and plvrb does in pl/sql?
What is schema in sql?
What are aggregate and scalar functions?
What is varchar example?
What has stored procedures in sql?
What is nosql db?
What is cursor and why it is required?
What is union, minus and interact commands?
Name the operator which is used in the query for pattern matching?
what are the performance and scalability characteristics of mysql? : Sql dba
Determine if oracle date is on a weekend?
Which sql statement is used to delete data from a database?
How many unique keys can a table have?
What is the use of & in pl sql?