title: Is the Else part of Case When statement ignored in PL/SQL?
body: <p>Why "else" part is not working I don't understand. Normally it should returns reverse of numbers if case statement not provided.</p>
  
  <p>Here is my code;</p>
  
  <pre><code>select Id,
         case 
           when mod(Id,10)&lt;(Id/10) 
             then (cast((Id/10) as number(5))*10)+(mod(Id,10)) 
           else 
             mod(Id,10)*10+(Id/10)  
         end Col
  from digits
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/RYkVq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RYkVq.jpg" alt="Sample Data"></a></p>
  
  <p>Sample data;</p>
  
  <pre>
  CREATE TABLE Test
  (
      Id INT
  );
  
  insert into test
  select 21 from dual
  UNION ALL
  select 12 from dual
  UNION ALL
  select 34 from dual
  UNION ALL
  select 43 from dual
  UNION ALL
  select 29 from dual
  UNION ALL
  select 92 from dual;
  </pre>
  
  <p>Thanks in advance..</p>