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

Explain the order of sql statement execution?

1045


Is sql a dbms?

1011


How many types of primary keys are there?

1038


Can we use ddl statements in stored procedure?

1154


What are the operators used in select statements?

1058


Can a foreign key have a different name?

940


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

999


Is big data nosql?

944


what is foreign key? : Sql dba

1049


What is the usage of the distinct keyword?

1220


What are analytical functions in sql?

1028


give the syntax of grant and revoke commands? : Sql dba

1151


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1153


Why is pl sql used?

981


what is a database? : Sql dba

1170