What are the advantages of the packages

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / deva

6 Answers
11990 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the advantages of the packages..

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.

Is This Answer Correct ?

11 Yes

0 No

What are the advantages of the packages..

Answer / akki julakanti

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

Is This Answer Correct ?

4 Yes

0 No

What are the advantages of the packages..

Answer / chandrasekar.ramasamy

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

Is This Answer Correct ?

3 Yes

0 No

What are the advantages of the packages..

Answer / manoj kaushik

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

Is This Answer Correct ?

4 Yes

1 No

What are the advantages of the packages..

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)

Is This Answer Correct ?

0 Yes

0 No

What are the advantages of the packages..

Answer / gireesh.p.v

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

Is This Answer Correct ?

0 Yes

2 No

Post New Answer