SQL Error ORA-00933 SQL command not properly ended

Question

I am trying to update a record in oracle SQL developer by using Joins  Following is my query-  UPDATE system info set field value    NewValue   FROM system users users  JOIN system info info ON users role type   info field desc  where users user name    uname    However  when I tried to execute it  I got following error-  Error report  SQL Error  ORA-00933  SQL command not properly ended                00933  00000 -  SQL command not properly ended    I tried removing JOINS  UPDATE system info info  SET info field value    NewValue   FROM system users users  where users user name    uname  AND users role type   info field desc   but still having same error can anybody tell me the error reason and solution

User · Answer

its very true on oracle as well as sql is "users" is a reserved words just change it , it will serve u the best if u like change it to this

UPDATE system_info set field_value = 'NewValue'

FROM system_users users JOIN system_info info ON users.role_type = info.field_desc where users.user_name = 'uname'

User · Answer

Not exactly the case of actual context of this question  but this exception can be reproduced by the next query   update users set dismissal reason  he can t and don t want  where userid 123   Single quotes in words can t and don t broke the string   In case string have only one inside quote e g   he don t want  oracle throws more relevant quoted string not properly terminated error  but in case of two SQL command not properly ended is thrown    Summary  check your query for double single quotes

User · Answer

Your query should look like  UPDATE table name SET column1 value  column2 value2     WHERE some column some value   You can check the below question for help    SQL update query using joins

User · Answer

Oracle does not allow joining tables in an UPDATE statement  You need to rewrite your statement with a co-related sub-select  Something like this    UPDATE system info SET field value    NewValue   WHERE field desc IN  SELECT role type                       FROM system users                       WHERE user name    uname     For a complete description on the  valid  syntax of the UPDATE statement  please read the manual   http   docs oracle com cd E11882 01 server 112 e26088 statements 10008 htm i2067715

User · Answer

Semicolon   on the end of command had caused the same error on me    cmd CommandText    INSERT INTO U USERS TABLE  USERNAME  PASSWORD  FIRSTNAME  LASTNAME  VALUES                            txtUsername Text                                txtPassword Text                                txtFirstname Text                                txtLastname Text           lt    Semicolon in    is the cause                                                        Removing it will be fine    Hope it helps

[sql] SQL Error: ORA-00933: SQL command not properly ended

Examples related to sql

Examples related to oracle