Functions and procedures can be defined using SQL procedural extensions that allow iteration and conditional statements.  Example: Following is a function developed,