Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the benefits of using PL/SQL packages?

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


Please Help Members By Posting Answers For Below Questions

What is materialized view. What are different methods of refresh?

1445


Can we update views in sql?

992


what are the advantages of sql ? : Sql dba

1114


What is difference between mysql and postgresql?

1240


How to run sql functions in pl/sql?

1126


What is sqlerrm?

991


What are actual parameters and formal parameters?

1180


What are the packages in pl sql?

1067


What is lexical units in pl sql?

1210


What is sql clause?

1092


What is the life of an sql statement?

1076


Explain the difference between triggers and constraints?

1025


What are the different types of functions in sql?

1101


What is form and report?

1057


Can 2 queries be executed simultaneously in a distributed database system?

1194