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
What are types of joins?
what is a stored procedure? : Sql dba
What is the trigger in sql?
How do you break a loop in pl sql?
What is normalization? How many normalization forms are there?
what does it mean to have quoted_identifier on? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Is nosql relational?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
How do I clear the screen in sql plus?
What is the difference between local and global temporary table?
How do I use google cloud in sql?
what is subquery? : Sql dba
what is bcp? When is it used?