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 are string data types? : Sql dba

0 Answers  

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

Is sql microsoft?

0 Answers  

What is a sql select statement?

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

What is dba in sql? : SQL DBA

0 Answers  

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

Explain the working of foreign key?

0 Answers  

What is on delete set null?

0 Answers  

Explain table and field in sql?

0 Answers  

What are the different types of joins in sql?

3 Answers  

what is sql profiler

2 Answers   Fidelity,