SQL Error ORA-00933 SQL command not properly ended

0 votes

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

Nov 4 in Others by gaurav
• 22,040 points
63 views

1 answer to this question.

0 votes

Installing SQLPlus on Windows:

  1. Step 1: First browse to this link.
  2. Step 2: Then we have to click on the download button on the right side.
  3. Step 3: Then on the next page you will find the Start Download button. ...
  4. Step 4: Then in the downloaded zip file there will be a setup.exe file.
answered Nov 7 by gaurav
• 22,040 points

Related Questions In Others

0 votes
1 answer

ERROR:'keytool' is not recognized as an internal or external command, operable program or batch file

Check if the directory and the keytool ...READ MORE

answered Feb 18 in Others by Rahul
• 9,680 points
3,922 views
0 votes
3 answers

error "VT-x is not available (VERR_VMX_NO_VMX)."

Either the VT-x is disabled in the BIOS ...READ MORE

answered Oct 27, 2020 in Others by Diksha
• 140 points

edited Oct 27, 2020 by Gitika 607 views
0 votes
1 answer

I am trying to run following command But I end up with an error :

Hii Nishant, You are running this command inside ...READ MORE

answered Apr 6, 2020 in Others by Niroj
• 82,800 points
939 views
0 votes
1 answer

Automating Oracle script with nolio

Depending upon the details of your script ...READ MORE

answered Jul 17, 2018 in Other DevOps Questions by ajs3033
• 7,280 points
377 views
0 votes
1 answer

Is there any boolean type in Oracle database?

Nope. I don't think there is one But ...READ MORE

answered Oct 10, 2018 in Database by Neha
• 6,300 points
362 views
0 votes
1 answer

Please name some online websites to compile and run PL/SQL?

For executing Oracle SQL queries and PL/SQL ...READ MORE

answered Feb 11 in Database by Neha
• 8,940 points
213 views
0 votes
1 answer

ORACLE LIVE SQL IMPORT CSV DATA (live oracle sql)

Convert CSV to SQL http://www.convertcsv.com/csv-to-sql.htm This programme may be ...READ MORE

answered Feb 11 in Database by Neha
• 8,940 points
4,192 views
0 votes
1 answer

'App not Installed' Error on Android

In order to allow installation of apps ...READ MORE

answered Nov 4 in Others by gaurav
• 22,040 points
45 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP