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 advantages of package?

Answer Posted / madhavi

The main advantage of package is one time compilation
process.while the first time of compilation the source code
is converted into P-code and stored in the database so that
for n no of time calling the pckg it does not take any
memory locations...
*Then whatevere the database objects declared in the
package specification will be globally accessible.

Is This Answer Correct ?    18 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a sql database?

996


What is sql resultset?

984


which types of join is used in sql widely? : Sql dba

982


How many tables can you join in sql?

957


What do you mean by “trigger” in sql?

1077


how to include numeric values in sql statements? : Sql dba

1098


How many joins in sql?

1008


How many types of triggers exist in pl/sql?

1071


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1066


Can a view be mutating? If yes, then how?

1026


How to test for null values?

1050


Why does sql need a server?

1037


Which is better cte or subquery?

1027


What is aggregate function in sql?

1036


Enlist some predefined exceptions?

1059