title: Oracle case function
body: <p>The below expression is not working,actually i want to update sal and desg based on below condition using case</p>
  
  <pre><code>SELECT SAL,
  CASE SAL  WHEN     SAL BETWEEN 3000 AND 5000 THEN SAL=SAL+(0.2*SAL) AND DESG='DEO'
            WHEN     SAL BETWEEN 5001 AND 7000 THEN SAL=SAL+(.15*SAL) AND DESG='ENGNRR'
            WHEN     SAL  BETWEEN 7001 AND 10000 THEN SAL=SAL+(0.25*SAL) AND DESG='SSE'
            WHEN     SAL &gt;1000 THEN SAL=SAL +(0.15*SAL) AND DESG='PSE'
                `    `ELSE SAL=SAL+1500 AND DESG='TL'
                END 
                 FROM SAMPLES
  </code></pre>
  
  <p>My Table name is samples</p>