Oracle Database 12c The Complete Reference

CHAPTER35Procedures, Functions, and Packages

Sophisticated business rules and application logic can be stored as procedures within Oracle. Stored procedures—groups of SQL, PL/SQL, and Java statements—enable you to move code that enforces business rules from your application to the database. As a result, the code will be stored once for use by multiple applications. Because Oracle supports stored procedures, the code within your applications can become more consistent and easier to maintain.

NOTE

For details on Java and its use in stored procedures, ...