Purpose
For a CONNECT BY query, this function returns whether a row is a leaf within the tree. For more information, refer to the description of the SELECT statement in the Query language (DQL) section.
Syntax
connect_by_isleaf::=
Example
SELECT last_name, CONNECT_BY_ISLEAF,
SYS_CONNECT_BY_PATH(last_name, '/') "PATH"
FROM employees
CONNECT BY PRIOR employee_id = manager_id
START WITH last_name = 'Clark';Result
| LAST_NAME | CONNECT_BY_ISLEAF | PATH |
| Clark | 0 | /Clark |
| Smith | 0 | /Clark/Smith |
| Brown | 1 | /Clark/Smith/Brown |
| Jones | 1 | /Clark/Smith/Jones |
