General functions

Applies to ✅ 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.

Table of contents

3.8.9.1.

CHOOSE

3.8.9.2.

COALESCE

3.8.9.3.

DECODE

3.8.9.4.

IIF

3.8.9.5.

NULLIF

3.8.9.6.

NVL

3.8.9.7.

NVL2