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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the benefits of using PL/SQL packages?

Question Posted / nashiinformaticssolutions

Answers were Sorted based on User's Feedback



What are the benefits of using PL/SQL packages?..

Answer / 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

What are the benefits of using PL/SQL packages?..

Answer / 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

What are the benefits of using PL/SQL packages?..

Answer / 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

More SQL PLSQL Interview Questions

What are inbuilt functions in sql?

0 Answers  

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

How many LONG columns are allowed in a table?

6 Answers   CTS,

what is union, minus and interact commands? : Sql dba

0 Answers  

What is integrity constraints?

5 Answers   Ramco, Satyam,

What is sql and how does it work?

0 Answers  

How many sql statements are used?

0 Answers  

Can we use threading in pl/sql?

0 Answers  

what is the different between now() and current_date()? : Sql dba

0 Answers  

What is record data type?

0 Answers  

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

For more SQL PLSQL Interview Questions Click Here
Categories