I am a beginner with these functions and I'm hoping someone can explain the ISLEAF results in this query. The results are producing the correct hierarchy.
SELECT ETC_ID, SYS_CONNECT_BY_PATH(etc_id
, '$') ids,
me, '$') names,
WHERE ETC_RETIRED_IND = 0
CONNECT BY ETC_PARENT_ETC_ID = PRIOR etc_id
START WITH ETC_PARENT_ETC_ID = 0
I attached a sample Excel output of a few records.
I am wondering why the first 2 records have ISLEAF = 0 (High level explanation of why I should expect that result)