java.sql.SQLException: ORA-00933: SQL command not properly ended

java.sql.SQLException: ORA-00933: SQL command not properly ended
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:789)
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)
 at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:829)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1115)
 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1263)
 at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)

 

ORA-00933 SQL   command   not   properly   ended
  Cause: The   SQL   statement   ends   with   an   inappropriate   clause.   For   example,   an   ORDER   BY   clause   may   have   been   included   in   a   CREATE   VIEW   or   INSERT   statement.   ORDER   BY   may   not   be   used   to   create   an   ordered   view   or   to   insertin   a   certain   order.   Also,   an   improper   SQL   ending   occurs   if   IN   clause   is   used   with   only   one   argument   (IN(X),   for   example).   An   IN   clause   must   have   two   or   more   arguments.    
  Action: Correct   the   syntax   by   removing   the   inappropriate   clauses.   It   may   be   possible   to   duplicate   the   removed   clause   with   another   SQL   statement.   For   example,   to   order   the   rows   of   a   view,   do   so   when   querying   the   view   and   not   when   creating   it.   This   error   can   also   occur   in   SQL*Forms   applications   if   a   continuation   line   is   indented.   Check   for   indented   lines   and   delete   these   spaces.    
   
  Copyright   (C)   1995,   Oracle   Corporation

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值