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

why we go for package? what are the advantages of using
instead of seperate procuderes or functions

Answer Posted / aravinda

package is collection of logically related pl/sql types
,items, subprograms. packages have following advantages over
procedures and functions.

Modularity, easy to design applications, information hiding,
added functionality and best performance.

we can declare global variables in packages which are valid
across application.

without invalidating the package we can modify the package body.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between partitioning and sharding?

1008


How do I run a query in pl sql developer?

993


Can we enter data in a table in design view?

967


how to drop an existing view in mysql? : Sql dba

1060


What is update query?

980


what are the types of join and explain each? : Sql dba

1037


what is single byte over head in oracle..?

2401


What are literals in sql server?

1170


What mean sql?

1007


Is sql pronounced sequel or sql?

1260


What is the size of partition table?

1046


When sql appeared?

1096


What is a rank in sql?

963


What is full join in sql?

991


Is primary key clustered or nonclustered?

1021