Answer Posted / glibwaresoftsolutions
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
How do you delete data from a table?
What is primary key and unique key?
What is difference sql and mysql?
What are commit, rollback, and savepoint?
What is difference between db2 and sql?
What is sql and db2?
Is not equal in sql?
what are the different type of sql's statements ? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Enlist the data types that can be used in pl/sql?
What are different types of queries in sql?
Explain the select statement in sql?
What is relationship? How many types of relationship are there?
How can you get sql*loader to commit only at the end of the load file? : aql loader
what is auto increment? : Sql dba