title: update set from inner join query thowing error
body: <p>I want to run a query like:</p>
  
  <pre><code>UPDATE   I
  SET I.CAP_NAME =  S.CAP_NAME 
  FROM INSURED_FARMERS  I 
  INNER JOIN INDIAN_STATES_REGION  S 
     ON UPPER(I.STATE_NAME_FI) = UPPER(S.STATE_NAME)
  </code></pre>
  
  <p>but it throws an error: sql error ora-00933 sql command not properly ended on line:
  SET I.CAP_NAME =  S.CAP_NAME </p>