Answer / rajesh

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

Answer / akki julakanti

Advantages of Packages:
1.Encapsulation
2.Overloading
3.Better Performance
4.Information hiding

Answer / chandrasekar.ramasamy

Package-> Compiles and stores all the procedures and
functions in SGA (System Global Area), so the performance
will be high.

Answer / manoj kaushik

Advantages of Packages --Modularity,Easier Application
Design,Information Hiding,Added Functionality,Better
Performance.

Answer / senthilkumar

Package is a group of related database objects like
functions ,procedures and other packages construct together
as a unit in the database.

Advantages:
Modularity
Better Performance(when we are executing any
subprogram in the package, it will be loaded in to the
memory, so performance of the package will be very high)

Answer / gireesh.p.v

package is a collection of procedures&functions.
we can use package by simply calling it

What is the primary key?

0 Answers  

Can we join tables without foreign key?

0 Answers  

what is 'mysqld'? : Sql dba

0 Answers  

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

Why are aggregate functions called so?

0 Answers  

What is sql used for?

0 Answers  

What is pragma in pl sql?

0 Answers  

What is the use of index in hive?

0 Answers  

What are the most important ddl statements in sql?

0 Answers  

what is normalization? : Sql dba

0 Answers  

how do you know the version of your mysql server? : Sql dba

0 Answers