Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
CONNECT BY functions
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The CONNECT BY clause is a vendor specific clause used for hierarchical SQL, in the context of which a few CONNECT BY specific functions, operators, and pseudo fields are available. These functions allow for retrieving recursion state and collect paths within the recursion.
Table of contents
- 3.11.22.1.
- CONNECT_BY_ISCYCLE
- 3.11.22.2.
- CONNECT_BY_ISLEAF
- 3.11.22.3.
- CONNECT_BY_ROOT
- 3.11.22.4.
- LEVEL
- 3.11.22.5.
- PRIOR
- 3.11.22.6.
- SYS_CONNECT_BY_PATH
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!