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
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.8.17.1.
- CONNECT_BY_ISCYCLE
- 3.8.17.2.
- CONNECT_BY_ISLEAF
- 3.8.17.3.
- CONNECT_BY_ROOT
- 3.8.17.4.
- LEVEL
- 3.8.17.5.
- PRIOR
- 3.8.17.6.
- SYS_CONNECT_BY_PATH
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!