| 1 |
Procedure or Function - a set of SQL and PL/SQL statements grouped together as an executable unit to perform a specific task
|
| 2 |
Procedures and functions allow user to combine the ease and flexibility of SQL with the procedural functionality of a structured programming language
|
| 3 |
Using PL/SQL, such procedures and functions can be defined and stored in the database for reuse
|
| 4 |
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
|
| 5 |
more details about procedure/function/package will be covered in 'PL/SQL' section in second module
|
