sql - 甲骨文 ORA-00933 : SQL command not properly ended?

Question

我一直收到这个错误。
我该如何解决这个问题？

错误:

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

代码:

<update id="updateProc" parameterClass="rating">
 update rating set
 rating_title=#rating_title#
 rating_cont=#rating_cont#
 where mem_id=#mem_id# 
 and rating_code=#rating_code#         
</update>   

Answer 1

请将 , 放在 Set 子句的列之间，例如:

update rating set rating_title=#rating_title#, rating_cont=#rating_cont#
where mem_id=#mem_id# and rating_code=#rating_code#