Answer Posted / hr@tgksolutions.com
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 two tables have same primary key?
Is sql similar to python?
What is user in sql?
Can we insert data in view?
What is foreign key sql?
What is cursor and its types?
What is localdb mssqllocaldb?
what's the difference between a primary key and a unique key? : Sql dba
Why are aggregate functions called so?
Why is stored procedure faster than query?
What is left join in sql?
what are the advantages and disadvantages of views in a database? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is sql clause?
what is blob? : Sql dba