title: SQL Update,Delete And Insert In Same Time
body: <p>I just curious about something. Let said i have a table which i will update the value, then deleted it and then insert a new 1. It will be pretty easy if i write the coding in such way:</p>
  
  <pre><code>  UPDATE PS_EMAIL_ADDRESSES SET PREF_EMAIL_FLAG='N' WHERE EMPLID IN ('K0G004');
  
    DELETE  FROM PS_EMAIL_ADDRESSES WHERE EMPLID='K0G004' AND E_ADDR_TYPE='BUSN';
  
    INSERT INTO PS_EMAIL_ADDRESSES VALUES('K0G004', 'BUSN', 'ABS@GNC.COM.BZ', 'Y');
  </code></pre>
  
  <p>however, it will be much more easy if using 'update' statement. but My question was, it that possible that done this 3 step in the same time?</p>