Thursday, 8 October 2015



Packages


A package is an oracle object, which holds other objects within it. Objects commonly held within a package are Procedures, variables, constants, cursors and exceptions. It is method of creating generic, encapsulation re-useable code. A package once written and debugged is compiled and stored in Oracle's system tables held in an Oracle Database.


Advantages of PL/SQL Packages

Packages have many advantages like modularity, easier application design, added functionality and increase performance.


1 comment: