Thread: Oracle Package

What is package ? Advantages of package ?

Pradeep,

A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification or spec or package header and Package Body

Please read the complete tutorials on packages . Oracle 9i Packages

Thanks,

package is collection of procedures and funtion and cursors..
there are two types of packages 1) Package specification and 2) Package Body,
(or)
package is schema object that are groped related collecation of objects and pl/sql datatypes and subprograms and items,

advantages of packages: modurality,easi application creation,better performance and information hiding...

for more details go through following
docs.oracle.com/cd/B10501_01/appdev.920/a96624/09_packs.htm
docs.oracle.com/cd/E14072_01/appdev.112/e10472/packages.htm

package is schema that groups related pl/sql data types and items and sub-programs.
(or)
package is collection of cursors and functions and procedures..

Advantages of Package:-
Better performance,modularity,infromation hiding,