Dynamic Navigation Menu With Sub Menu Manually In Oracle Apex

Here is the SQL to do the Dynamic Navigation Menu With Sub Menu. The details watch the video.

SELECT LEVEL,
                  ENAME label,
                  'f?p=&OBNK.:' || '1' || ':' ||:APP_SESSION||':'||EMPNO target,
  SAL is_current,
 'fa-angle-double-right' image,                  
                  MGR 
             FROM EMP                 
       START WITH MGR IS NULL
       CONNECT BY PRIOR EMPNO = MGR
ORDER SIBLINGS BY EMPNO