메뉴생성(왼쪽 색션별)-Query

SELECT level,
       a.id,
       a.ref,
       a.menu_name,
       a.param,
       a.url,
       a.chk_cmd,
       a.sort_order,
       folder_sect,
       roll_over_on_img,
       roll_over_off_img
FROM   (SELECT b.id,
               b.ref,
               b.url,
               b.param,
               b.menu_name,
               b.sort_order,
               b.folder_sect,
               b.chk_cmd,
               b.roll_over_on_img,
               b.roll_over_off_img
        FROM   메뉴권한매핑 a,
               메뉴마스터 b
        WHERE  a.menu_seq = b.seq
        AND    b.use_yn = 'Y'
        AND    b.menu_name <> '-'
        AND    a.type_seq = 14) a
WHERE  1 = 1 CONNECT BY PRIOR a.id = a.ref START WITH a.ref = 0
ORDER siblings BY a.sort_order