title: How to Update value for multiple Field in Oracle SQL
body: <p>I have to update field: Number, Tgl, product in Table Detail_product from table Details
  with condition:</p>
  <pre><code>If, id on Table Detail Product an Detail is same then 
  update Detail_product.Tgl using Details.tgl where Details.tgl is null,
  update Detail_product.number using Details.number  where Details.number 
  update Detail_product.product using Details.product  where Details.product
  </code></pre>
  <p>I have query merge to update field, but i can't create one query to update multiple field</p>
  <pre><code>MERGE INTO Detail_product x
  USING Details y
  ON (x.id = y.id)
    WHEN MATCHED THEN
  UPDATE SET x.tgl = y.tgl WHERE Y.tgl IS NOT NULL; 
  
  MERGE INTO Detail_product x
  USING Details y
  ON (x.id = y.id)
    WHEN MATCHED THEN
  UPDATE SET x.number = y.number WHERE Y.number IS NOT NULL; 
  
  MERGE INTO Detail_product x
  USING Details y
  ON (x.id = y.id)
    WHEN MATCHED THEN
  UPDATE SET x.product = y.product WHERE Y.product IS NOT NULL; 
  </code></pre>
  <p>What should i do, so the query is sort and the runtime doesn't take long.</p>