Error At Line 2 Ora-00933 Sql Command Not Properly Ended
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss ora 00933 sql command not properly ended in select query the workings and policies of this site About Us Learn more about ora 00933 sql command not properly ended insert multiple Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions ora-00933 sql command not properly ended select Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
Ora-00933 Sql Command Not Properly Ended Update
Join them; it only takes a minute: Sign up SQL Error: ORA-00933: SQL command not properly ended up vote 7 down vote favorite 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 ora-00933 sql command not properly ended insert 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 sql oracle share|improve this question edited Jan 20 '12 at 11:10 Mark Bannister 34.4k32450 asked Jan 20 '12 at 11:07 Microsoft DN 5,05932345 I think your sqlDevelepor executed the previous line. put a semi colon before and after your sql statement and try again –You Qi Jan 20 '12 at 11:11 I tried your solution, but not working for me –Microsoft DN Jan 20 '12 at 11:16 add a comment| 5 Answers 5 active oldest votes up vote 9 down vote accepted Oracle does not allow joining tables in an UPDATE statement. You need to rewrite your statement with a co-related sub
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss sql command not properly ended join the workings and policies of this site About Us Learn more about
Sql Command Not Properly Ended Oracle
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Sql Command Not Properly Ended Group By
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. http://stackoverflow.com/questions/8940471/sql-error-ora-00933-sql-command-not-properly-ended Join them; it only takes a minute: Sign up Oracle ORA-00933: SQL command not properly ended? up vote 3 down vote favorite I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Code:
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND https://www.techonthenet.com/oracle/errors/ora00933.php AND & OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions sql command Analytic Functions Advanced Functions Oracle / PLSQL: ORA-00933 Learn the cause and how to resolve the ORA-00933 error message in Oracle. Description When you encounter an ORA-00933 error, the following error message will appear: ORA-00933: SQL command not properly ended Cause You tried to execute a SQL statement with an inappropriate clause. Resolution The option(s) to resolve this Oracle error are: Option #1 You may sql command not have executed a INSERT statement with a ORDER BY clause. To resolve this, remove the ORDER BY clause and re-execute the INSERT statement. For example, you tried to execute the following INSERT statement: INSERT INTO supplier (supplier_id, supplier_name) VALUES (24553, 'IBM') ORDER BY supplier_id; You can correct the INSERT statement by removing the ORDER BY clause as follows: INSERT INTO supplier (supplier_id, supplier_name) VALUES (24553, 'IBM'); Option #2 You may have tried to execute a DELETE statement with a ORDER BY clause. To resolve this, remove the ORDER BY clause and re-execute the DELETE statement. For example, you tried to execute the following DELETE statement: DELETE FROM supplier WHERE supplier_name = 'IBM' ORDER BY supplier_id; You can correct the DELETE statement by removing the ORDER BY clause as follows: DELETE FROM supplier WHERE supplier_name = 'IBM'; Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.