title: PL/SQL using IF statement inside Update
body: <p>Was wondering if something like this:</p>
  
  <pre><code>begin
      for C2 in cursor_sal loop
          if something then
              update emp
              set name = George
              where ID = 1
          elsif something2 then
              update emp
              set name = Steve
              where ID = 4
          end if
      end loop;
  end;
  </code></pre>
  
  <p>Could be turned into something like this or anything similar:</p>
  
  <pre><code>begin
      for C2 in cursor_sal loop
          update emp
          if something then
              set name = George
          elsif something2 then
              set name = Steve
          end if
          where current of C2
      end loop;
  end;
  </code></pre>
  
  <p>Or is this just not possible and an I stuck with the first example?</p>