CONNECT_BY_ISLEAF functionality available in PSQUERY?
We are currently on HCM 9.1/ PT 8.50
We are in the process of upgrading to HCM 9.2/PT 8.53
I have started using the CONNECT_BY_ISLEAF in sqlplus but would like to be able to do similar in PSQUERY.
Here is my SQL that I use in SQLPLUS:
SELECT last_name||Emplid "Employee", CONNECT_BY_ISLEAF "IsLeaf",
LEVEL, SYS_CONNECT_BY_PATH(last_name||emplid, '/') "Path"
FROM ps_employees
WHERE LEVEL <= 4
START WITH emplid = '012345'
CONNECT BY PRIOR emplid = supervisor_id AND LEVEL <= 5
ORDER BY "Employee", "IsLeaf"
/
An HR user is now asking for SQL Developer access because he is unable to do things like this in PSQUERY.