ORACLE MVIEW
CREATE MATERIALIZED VIEW MV_EVT_LEDG BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND START WITH TO_DATE('16-02-2017 07:00:00', 'DD-MM-YYYY HH24:MI:SS') NEXT SYSDATE + 1 AS SELECT BULD_NM, a.ELEVATOR_NO, ELVTR_ASIGN_NO, ELVTR_STTS_CD, C.COMPANY_NM, C.sub_COMPANY_NM, C.CONT_BEGIN_DATE, C.CONT_END_DATE, AREA_NO, SIGUNGU_CD, SEL_CHK_MM, A.ELVTR_MGT_NO1, A.ELVTR_MGT_NO2, DECODE(A.ELVTR_STTS_CD,'01','정상','휴지') ELVTR_STTS_NM,B.BULD_MGT_NO1,B.BULD_MGT_NO2,B.ADDRESS1||B.ADDRESS2 as address from tn_elvtr_ledg a, tn_buld_ledg b, (SELECT ELEVATOR_NO, A.KEEP_MNT_CONT_NO, CONT_BEGIN_DATE, ...