코딩 관련/오류 관련
ORA-00907: missing right parenthesis
메리짱123
2021. 2. 2. 16:12
반응형
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 : 괄호
쿼리문의 괄호 짝이 안맞는거였음... 빠진 괄호를 넣어주자... )))))
반응형