Interested to Buy Any Domain ? << Click Here >> for more details...
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 is column? : Sql dba
How to connect a sql*plus session to an oracle server?
How many types of tables are there?
What is the use of index in hive?
What information is needed to connect sql*plus an oracle server?
What is sql lookup?
What is linq to sql?
how to see the create table statement of an existing table? : Sql dba
What are the types of index in sql?
Can we use pl sql in mysql?
what is 'trigger' in sql? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
explain the delete statements in sql
What is difference between table and view?
What is the clause we need to add in function body to return variable?
