답변 감사드립니다.

SELECT "MENU_CODE","MENU_NAME","DEPTH","PARENT_MENU_CODE","MENU_SEQ","USE_YN","APPROVAL_YN"
  FROM (SELECT     LPAD (' ', 10 * (LEVEL)) || menu_code menu_code, menu_name,
                   DEPTH, parent_menu_code, menu_seq, use_yn, approval_yn
              FROM (SELECT   *
                        FROM tb_cms_menu
                    ORDER BY menu_seq ASC)
             WHERE DEPTH <> 0
        CONNECT BY PRIOR menu_code = parent_menu_code
        START WITH DEPTH = 1)

강정기님 말씀데로 문제점에서 다시 생각해 보았습니다..

해결하고 나니 간단하네여..^^;;