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
Explain the order of sql statement execution?
Is sql a dbms?
How many types of primary keys are there?
Can we use ddl statements in stored procedure?
What are the operators used in select statements?
Can a foreign key have a different name?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Is big data nosql?
what is foreign key? : Sql dba
What is the usage of the distinct keyword?
What are analytical functions in sql?
give the syntax of grant and revoke commands? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Why is pl sql used?
what is a database? : Sql dba