[Query] Insert with
INSERT WITH INSERT INTO TB_ACC_OUT_CLS(CLS_DT, OUT_CST_CD, SC_CD, CST_CD, ITEM_CD ) WITH VI_CLS AS( SELECT A.REQ_DT , A.OUT_CD , B.SB_CD , B.CST_CD , A.ITEM_CD , SUM(1) REQ_CNT , SUM(NVL(A.TEST_AMT,0)) REQ_AMT , SUM(NVL(A.STU_AMT,0)) OUT_REQ_AMT FROM TB_DTL A , TB_MST B , TB_ITEM E , TB_OUT F WHERE A.REQ_NO = B.REQ_NO AND A.ITEM_CD = E.ITEM_CD AND E.STR_DT = TO_CHAR(SYSDATE,'YYYYMMDD') GROUP BY ..
2015. 7. 31.