Usage of routines

Routines can be used to solve many common problems faced by database architects, database administrators, and application developers alike. They can help improve the structure, maintenance, and performance of your applications.

The following list provides some examples of scenarios in which you might use routines:

Administering databases with routines
Extending SQL function support with user-defined functions
Auditing data changes using routines and other SQL features