当前位置: 代码迷 >> Oracle开发 >> java.sql.SQLException: ORA-00933: SQL command not properly ended,该怎么解决
  详细解决方案

java.sql.SQLException: ORA-00933: SQL command not properly ended,该怎么解决

热度:134   发布时间:2016-04-24 07:44:57.0
java.sql.SQLException: ORA-00933: SQL command not properly ended
java.sql.SQLException: ORA-00933: SQL command not properly ended,又没有遇到过,程序以前是正确的,后来我改了sql语句,sql单独运行也是正确的,但是放在java里就不行了。
sql:
sql = "select ORI_URL, count(*) as counter, count(*)/"+total+" as ratio "+
  "from KFWEB_VISIT"+
  "where ORI_URL not like '%192.168.0.200%' and ORI_URL not like '%192.168.0.100%' "+
  " group by ORI_URL"+
  " order by counter desc";

------解决方案--------------------
还是sql语句的问题,建议你好好检查一下
  相关解决方案