End-user routines
An end-user routine is an SQL-invoked function that the SQL user can include in an SQL statement. Such routines provide special functionality that application users often need. An end-user routine might be as simple as “increase the price of every item from XYZ Corporation by 5 percent” or something far more complicated.
- Built-in data types
The database server provides many functions that end users can use in SQL statements on built-in data types. These functions are called built-in functions to distinguish them from SQL-invoked functions that you define.
You cannot extend an existing built-in function on a built-in data type that it supports. However, you can perform the following extensions:- Define your own end-user routines to provide new or similar functionality.
- Define a UDR that has the same name as a built-in function but operates on a different built-in data type.
For more information about built-in functions, see Extend operators and built-in functions.
- Extended data types
You can write an end-user routine on any data type that is registered in the database.
For more information about end-user routines, see Create an end-user routine.