All versions: 3.11 | 3.10 | 3.9 | 3.8 | 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | Development versions: 3.12 | Unsupported versions: 3.2 | 3.1 | 3.0 | 2.6

There are a variety of general functions supported by jOOQ As discussed in the chapter about SQL dialects functions are mostly emulated in your database, in case they are not natively supported.

This is a list of general functions supported by jOOQ's DSL:

  • COALESCE: Get the first non-null value in a list of arguments.
  • NULLIF: Return NULL if both arguments are equal, or the first argument, otherwise.
  • NVL: Get the first non-null value among two arguments.
  • NVL2: Get the second argument if the first is null, or the third argument, otherwise.

Please refer to the DSL Javadoc for more details.

The jOOQ Logo