Shiva gupta

• Nov 25th, 2014

 

In package we simultaneously create multiple procedure , function as well as cursor . In one program we create all of these but in procedure we cant create function and cursor.

Srividhya

• Dec 19th, 2014

 

Package is a collection of procedures, functions and cursors. advantages of packages . all the global variable will be loaded in memory. whereas in procedure it is not

Hema nagaraju

• Dec 19th, 2014

 

Packages are collection of functions,procedures,subprograms and cursors.packages improve the performance of application by executing all at once.

vijaysiddireddy

 Profile Answers by vijaysiddireddy 

• Dec 25th, 2014

 

With package all the related & dependent methods will be grouped. When ever a method is called from the package all the related methods will be activated in memory. So we can find a small improvement in performance of the application.

mashavi

• Dec 29th, 2014

 

package is a collection of functions,procedures and cursors so that we can perform multiple tasks at a time.

jkcboys

• Jan 4th, 2015

 

packages will be pre-compiled components, will improve performance compare to standalone one.

abhijit musale

• Feb 18th, 2015

 

you can wrap/encrypt the package code .

Habib Ali

• May 9th, 2016

 

Packages can be cached inside the SGA, resulting in faster execution than a normal stored procedure.