오라클 VIEW

기존 포인트 합계 VIEW 쿼리문은 다음과 같았다. -- 총 합계 VIEW CREATE OR REPLACE VIEW VIEW_POINT AS SELECT M.CODE, (NVL(R.AMOUNT, 0) + NVL(C.AMOUNT, 0) - NVL(P.AMOUNT, 0) - NVL(W.AMOUNT, 0) + NVL(CH.AMOUNT, 0)) AS POINT FROM MEMBER M FULL OUTER JOIN VIEW_REFUND R ON M.CODE = R.MEMBER_CODE FULL OUTER JOIN VIEW_COMPLETE C ON R.MEMBER_CODE = C.MEMBER_CODE FULL OUTER JOIN VIEW_PAYMENT P ON C.MEMBER_CODE = P.MEMBER_CODE ..