jvoconnell
asked on
ISLEAF explanation
Experts,
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,
SYS_CONNECT_BY_PATH(etc_na me, '$') names,
CONNECT_BY_ISLEAF isleaf
FROM ETC_TBL
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)
isleaf-example.xlsx
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
SYS_CONNECT_BY_PATH(etc_na
CONNECT_BY_ISLEAF isleaf
FROM ETC_TBL
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)
isleaf-example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER