Develop Note

 SELECT PROJECT_CODE
       ,PROJECT_NAME
       ,PROJECT_AMT
       ,(SELECT SUM(PROJECT_AMT)
           FROM PROJECT 
          START WITH PROJECT_CODE = A.PROJECT_CODE
        CONNECT BY PRIOR PROJECT_CODE = P_PROJECT_CODE) SUM_AMT
   FROM PROJECT A
  START WITH P_PROJECT_CODE IS NULL
CONNECT BY PRIOR PROJECT_CODE = P_PROJECT_CODE;

계층 쿼리에서 제일 하위노드에서 상위노드로 합산해서 금액 보여주기.

* 결과값 *