Answer Posted / nashiinformaticssolutions
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 is materialized view. What are different methods of refresh?
Can we update views in sql?
what are the advantages of sql ? : Sql dba
What is difference between mysql and postgresql?
How to run sql functions in pl/sql?
What is sqlerrm?
What are actual parameters and formal parameters?
What are the packages in pl sql?
What is lexical units in pl sql?
What is sql clause?
What is the life of an sql statement?
Explain the difference between triggers and constraints?
What are the different types of functions in sql?
What is form and report?
Can 2 queries be executed simultaneously in a distributed database system?