Ora-00933 for update

Please enter your email address. You will receive a link and will create a new password via email. Please briefly explain why you feel this answer should be reported. Cause: The SQL statement ends with an inappropriate clause. 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.

I eventually figured it out. No problem! I am seeing this error when using a very basic query that seems to comply with all the rules and runs OK when run on Oracle. I have stripped back my query to make it as simple as possible to get this working. There are 37 rows in the target table. I have run this previously, to support querying linked server this way: EXEC master.

Hi Keith, that sounds like a tricky error. Take that out and it works. Many thanks. Tried this You need to correlate the subquery with the row being updated; probably o n the a.

Some explanation of what you're changing and why would be nice though, rather than just a code dump. GeorgeGeorgiou then in Subquery table2 there are multiple ids correspoding to id in table A. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

Podcast Making Agile work for data science. Oracle technology is changing and we strive to update our BC Oracle support information.

If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. Search BC Oracle Sites.