Array ( [code] => 933 [message] => ORA-00933: SQL command not properly ended [offset] => 71 [sqltext] => SELECT COUNT(E_IDX) AS TOTAL_CNT FROM CH_EVENT WHERE 1=1 AND GBN = 'B' USE_FLAG = 'Y' AND TO_DATE(END_DATE ,'YYYY-MM-DD') >= TO_DATE('2025-08-26' , 'YYYY-MM-DD') AND TO_DATE(BEGIN_DATE ,'YYYY-MM-DD') <= TO_DATE('2025-08-26' , 'YYYY-MM-DD') ) Array ( [code] => 907 [message] => ORA-00907: missing right parenthesis [offset] => 176 [sqltext] => SELECT * FROM ( SELECT CH_EVENT.*, TO_CHAR(REG_DATE, 'YYYY-MM-DD') AS C_REG_DATE , ROW_NUMBER() OVER(ORDER BY e_idx DESC) AS RNUM FROM CH_EVENT WHERE 1=1 AND GBN = 'B' USE_FLAG = 'Y' AND TO_DATE(END_DATE ,'YYYY-MM-DD') >= TO_DATE('2025-08-26' , 'YYYY-MM-DD') AND TO_DATE(BEGIN_DATE ,'YYYY-MM-DD') <= TO_DATE('2025-08-26' , 'YYYY-MM-DD') ORDER BY REG_DATE DESC ) WHERE RNUM < 7 AND RNUM > 0 )

혜택

이벤트

전체건이 검색되었습니다.