SELECT lpad('|-',(level-1)*4,' ')||lpad('『',2)||CAPTION||rpad('』',2) CAPTION
FROM TCPS_T_MENU_ASSET
CONNECT BY PRIOR MENU_ID=PARENT_ID
START WITH MENU_ID='1';
FROM TCPS_T_MENU_ASSET
CONNECT BY PRIOR MENU_ID=PARENT_ID
START WITH MENU_ID='1';