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
Can a varchar be a primary key?
What are the basic techniques of indexing?
what is the difference between truncate and delete statement? : Transact sql
What is the current version of sql?
What are different functions in sql?
What are the set operators in sql?
Can you sum a count in sql?
What is left join in sql?
How to rename a column in the output of sql query?
What is self-join and what is the requirement of self-join?
What is use of term?
What is sqlcontext?
What is rollback?
How to create a menu in sqlplus or pl/sql?
How can we implement rollback or commit statement in a trigger?