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

Answer 1

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.