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 different sql data types?
What is minus?
What is cascade in sql?
What are the differences between implicit and explicit cursors?
What is exception? What are the types of exceptions?
What are the constraints available in sql?
Can we use two order by clause in query?
What is trigger in pl sql?
Which sql statement is used to delete data from a database?
What is crud sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is the use of index in sql?
What are few of the schema objects that are created using PL/SQL?
What is the requirement of self-join?
What is program debugging?
