반응형 For Loop2 Oracle cursor 오라클에서 커서 사용하는 SP 샘플 create or replace PROCEDURE TEST IS o_ZIP_CD VARCHAR2(7) := ''; o_ZIP_SEQ VARCHAR2(3) := ''; o_JIBUN VARCHAR2(500) := ''; o_JI_SIDO VARCHAR2(50) := ''; o_JI_SIGUNGU VARCHAR2(50) := ''; o_JI_DONG VARCHAR2(50) := ''; o_JI_RI VARCHAR2(50) := ''; o_JI_OTHER VARCHAR2(300) := ''; ERR_USER_EXCEPTION EXCEPTION; BEGIN FOR C1 IN ( SELECT B.BRAN_CD , A.C09 AS ADDR FROM TEMP a , TEMP1 b .. 2017. 9. 13. [Query] FOR LOOP FOR LOOP FOR x IN ( WITH KEY_INFO AS ( SELECT ADD_MONTHS(TO_DATE(P_REQ_DT,'YYYYMMDD'),-1) REQ_DT FROM DUAL ) SELECT CLS_DT FROM ( SELECT TO_CHAR(REQ_DT + LEVEL,'YYYYMMDD') CLS_DT FROM KEY_INFO CONNECT BY LEVEL 2016. 1. 8. 이전 1 다음 반응형