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

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

How much does a sql dba make? : SQL DBA

0 Answers  

Explain the rollback statement?

0 Answers  

Can we rollback truncate?

0 Answers  

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

What is Raise_application_error ?

1 Answers  

Define sql delete statement.

0 Answers  

How do I quit sql?

0 Answers  

Name some usages of database trigger?

0 Answers  

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

What is java sql package?

0 Answers  

Is left join inner or outer?

0 Answers