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

What is clause?

1229


Can we use update in sql function?

1116


How do I send sql query results to excel?

1113


What is a constraint?

1084


what are myisam tables? : Sql dba

1079


What is the difference between an inner join and an outer join?

1085


Why we use stored procedure instead of query?

1047


Does varchar need length?

1050


How many indexes can be created on a table in sql?

1114


Which is the correct statement about truncate and delete?

1172


What are the string functions in sql?

1023


What is pl sql block structure?

1095


Which sql statement is used to delete data from a database?

1008


What is rank function in sql?

1072


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1008