|
Procedure or Function - a set of SQL and PL/SQL statements grouped together as an executable unit to perform a specific task
|
|
Procedures and functions allow user to combine the ease and flexibility of SQL with the procedural functionality of a structured programming language
|
|
Using PL/SQL, such procedures and functions can be defined and stored in the database for reuse
|
Package - provides a method of encapsulating and storing related procedures, functions, and other package constructs together as a unit in the database.
-
Packages provide DBA or developer organizational benefits, as well as increased functionality and database performance
|
|
more details about procedure/function/package will be covered in 'PL/SQL' section in second module
|
