|The jOOQ User Manual. Multiple Pages : SQL building : Column expressions : General functions||previous : next|
Available in ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
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 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.