Examples: UDF code

 

These examples show how to implement user-defined function (UDF) code by using SQL functions and external functions.

• Example: Square of a number UDF
  Suppose that you want a function that returns the square of a number.

• Example: Counter
  Suppose that you want to number the rows in a SELECT statement. So you write a user-defined function (UDF) that increments and returns a counter.

• Example: Weather table function
  Suppose that you write a table function that returns weather information for various cities in the United States.

 

Parent topic:

Using user-defined functions