Table expressions

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The following sections explain the various types of table expressions supported by jOOQ

Table of contents

4.7.1.

Generated Tables

4.7.2.

Aliased Tables

4.7.3.

Joined tables

4.7.4.

The VALUES() table constructor

4.7.5.

Nested SELECTs

4.7.6.

The Oracle 11g PIVOT clause

4.7.7.

jOOQ's relational division syntax

4.7.8.

Array and cursor unnesting

4.7.9.

Table-valued functions

4.7.10.

JSON_TABLE

4.7.11.

XMLTABLE

4.7.12.

The DUAL table

4.7.13.

Temporal tables