title: Oracle: Using CTE with update clause
body: <p>Can I make an update using common table expression in oracle database? </p>
  
  <p>I am getting error <code>ORA-00928: missing SELECT keyword</code> when I am trying this:</p>
  
  <pre><code>with average as (SELECT avg(salary) FROM instructor)
  update instructor
                 set salary = case
                     when salary &lt;= average then salary * 1.05 
                     else salary * 1.03                                     
                 end
  </code></pre>