Oracle Ora-00933: Sql Command Not Properly Ended?

I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Code:

Solution 1:

Please put , between your columns of Set Clause like:

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

Solution 2:

In Oracle, string literals are denoted by single quotes ('). So, if you plan to use literals:

UPDATE rating 
SET    rating_title='rating_title', rating_cont='rating_cont'WHERE  mem_id='mem_id'AND rating_code='rating_code'

Solution 3:

You can also get this exact same error if you have quotes that are not properly closed or you forget to use double quotes inside of a statement with single quotes on the outside.

Share