turtle

종료 : wsdown -i 시작 : wsboot 컴파일 : wscfl -i http.m

@NVL(SEL_CHK_DEG,'1')

-Xms256m -Xmx768m -XX:MaxPermSize=256m

VAR jobno NUMBER BEGIN   DBMS_JOB.SUBMIT(:jobno ,'PROC_BATCH;',SYSDATE,'SYSDATE+1/60/24'); END; / COMMIT; 1분마다 PROC_BATCH실행

set echo off set null @ set pages 0 set colsep ',' set trimspool on set lines 30000 set termout off spool ./20170222.csv select * from 테이블1 spool off

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,                        CONT_END_DATE,                        B.ELEVATOR_NO_YN,                        nvl(B.SEL_CHK_MM,1) SEL_CHK_MM,                        A.COMPANY_CD,                        SUB_COMPANY_CD,                        BULD_MGT_NO1,      

JSON 템플릿  http://jsonlint.com/