죄송합니다.
작업중 오류가 발생했습니다.
동일한 문제가 지속적으로 발생할 경우,
운영자에게 문의하십시오.
[ trace ]
FUNCTION kencaedu.TO_CHAR does not exist Query: SELECT Z.POLL_SEQ_NO, Z.TIT_NM, Z.NTC_ST_DT, Z.NTC_END_DT,
(SELECT COUNT(1) FROM TB_LS_POLL_EX WHERE POLL_SEQ_NO = Z.POLL_SEQ_NO),
(SELECT CASE WHEN COUNT(1) > 0 THEN 'Y' ELSE 'N' END FROM TB_LS_POLL_RSLT WHERE POLL_SEQ_NO = Z.POLL_SEQ_NO AND RESP_USER_NO = ?) RSLTYN
, CASE WHEN (TO_CHAR(SYSDATE, 'YYYYMMDD') - Z.NTC_END_DT) <= 0 THEN 'Y' ELSE 'N' END CHK_YN
FROM (
SELECT X.*, ROWNUM RO
FROM (
SELECT
A.POLL_SEQ_NO, A.TIT_NM, A.NTC_ST_DT, A.NTC_END_DT
FROM TB_LS_POLL A
WHERE A.NTC_YN = 'Y'
AND A.NTC_ST_DT <= TO_CHAR(SYSDATE, 'YYYYMMDD')
) X
) Z
WHERE RO BETWEEN ? AND ? Parameters: [, 1, 10]