I need help combining update statements into 1 statement
<p>I need to update around 500 records with the same <code>set</code> values but different <code>where</code> values in SQL (Oracle).  I want to execute as one statement instead of 500 different statements. Any help is appreciated. Below is an example my update statements.</p>

<pre><code>update proddta.f564211 
  set sd$prdcflg = '' 
where sd$prcflg = 'Y' 
AND sddoco = 86615 
and sddcto = 'S1' 
and sdlnid = 1.000

update proddta.f564211 
  set sd$prdcflg = '' 
where sd$prcflg = 'Y' 
AND sddoco = 86615 
and sddcto = 'S1' 
and sdlnid = 2.100

update proddta.f564211 
  set sd$prdcflg = '' 
where sd$prcflg = 'Y' 
AND sddoco = 86618 
and sddcto = 'S1' 
and sdlnid = 1.000

update proddta.f564211 
  set sd$prdcflg = '' 
where sd$prcflg = 'Y' 
AND sddoco = 86618 
and sddcto = 'S1' 
and sdlnid = 2.100
</code></pre>