Routines can be divided into the following two programming language categories:

• SQL routines
  Routines written in SQL
  
• External routines
  Routines written in languages other than SQL
  

Routines can be divided into two classes, depending on the definition SQL:

• Procedures
• Functions

Organization of this section

1.9.1 Procedures

1.9.2 Functions

1.9.3 Results-set return facility