| 1 |
PL/SQL Block - an unnamed PL/SQL procedure that groups SQL statements and PL/SQL constructs into a single program unit
|
| 2 |
Stored Procedures - A PL/SQL block stored in the database and called by name from applications
|
| 3 |
Stored Functions - identical to procedures except functions always retun a single value to the caller while procedures do not
|
| 4 |
Stored Packages - a method to encapsulate and store related procedures, functions, variables, and other package constructs together as a unit in the database
|
