애플자라

SELECT ROW_NUMBER() OVER (ORDER BY NAME ASC) AS EMS_M_ID, NAME AS EMS_M_NAME, TRIM(REPLACE(MOBILE,'-','')) AS EMS_M_PHONE FROM APLUSORA.TEMP_N_BOARD_EVENT ORDER BY NAME ASC

SELECT @RNUM := @RNUM + 1 AS ROWNUM, EVENT_SCHEMA, EVENT_NAME, INTERVAL_FIELD, EVENT_DEFINITION, LAST_EXECUTED FROM information_schema.EVENTS, (SELECT @RNUM := 0) R ORDER BY LAST_EXECUTED DESC

* TB_INST_INPUT테이블에 SUBS_VALUE 데이터가 |구분자로 값이 들어오는 경우 -- SUBS_VALUE 컬럼의 데이터를 | 구분자로 짤라 각각 매핍변수로 선언 SELECT SUB1,SUB2,SUB3,SUB4,SUB5,SUB6,SUB7,SUB8,SUB9,SUB10,SUB11,SUB12,SUB13,SUB14, SUB15 FROM(SELECT MAX(DECODE(rowno,1,aa)) SUB1 ,MAX(DECODE(rowno,2,aa)) SUB2 ,MAX(DECODE(rowno,3,aa)) SUB3 ,MAX(DECODE(rowno,4,aa)) SUB4 ,MAX(DECODE(rowno,5,aa)) SUB5 ,MAX(DECODE(rowno,6,aa)) SUB6 ,MAX(DECODE(rowno,7,..