반응형
ERROR jdbc.sqltiming - 1. PreparedStatement.execute() FAILED! select equi_type, avg(equi_cnt), sum(data_cnt), sum(normal_data_cnt) normal_data_cnt from (select equi_type, equi_cnt, data_cnt, equi_cnt*((select to_char(sysdate,'hh24') from dual)*30+'15') normal_data_cnt from tb_st_daily_sen where tm8=(select to_char(sysdate,'yyyymmdd') from dual)
{FAILED after 14 msec}
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
* parenthesis : 괄호
쿼리문의 괄호 짝이 안맞는거였음... 빠진 괄호를 넣어주자... )))))
반응형
'코딩 관련 > 오류 관련' 카테고리의 다른 글
| [JavaScript] Invalid left-hand side in assignment (1) | 2021.05.03 |
|---|---|
| ORA-00911: invalid character (0) | 2021.02.02 |
| No mapping found for HTTP request with URI (1) | 2020.12.16 |
| Could not instantiate bean class [java.util.List]: Specified class is an interface (0) | 2020.10.08 |
| java.util.NoSuchElementException (0) | 2020.10.06 |