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
What are all types of user defined functions?
Is postgresql a nosql database?
What is t-sql? : Transact sql
explain commit and rollback in mysql : sql dba
What is procedure and function?
How many sectors are in a partition?
What version is sql?
How many sql statements are used?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How do you respond to dementia behavior?
explain the delete statements in sql
what is union? : Sql dba
Which is faster union or join?
what is sql? : Sql dba
Is sql injection illegal?