title: how to update multiple rows in oracle
body: <p>I would like to update multiple rows with different values for all different records, but don't have any idea how to do that, i am using below sql to update for single record but i have 200 plus records to update</p>
  
  <pre><code>update employee
  set staff_no = 'ab123'
  where depno = 1
  </code></pre>
  
  <p>i have 50 dep and within those dep i need to update 200 plus staff no. any idea.
  At the moment if i just do a </p>
  
  <pre><code> select * from Departments 
  </code></pre>
  
  <p>i can see list of all employee which needs staff no updating.</p>
  
  <pre><code>UPDATE person
     SET staff_no = 
         CASE person_no
              WHEN 112 THEN 'ab123'
              WHEN 223 THEN 'ab324'
              WHEN 2343 THEN 'asb324'
              and so on.....
  
  
         END
  </code></pre>