title: How many WHEN....THEN Condition is allow in CASE in SQL
body: <p>I am working with the CASE &amp; DECODE. 
  The SYNTAX of CASE is : </p>
  
  <pre><code>CASE  [ expression ]
    WHEN condition_1 THEN result_1
    WHEN condition_2 THEN result_2
    ...
    WHEN condition_n THEN result_n
    ELSE result
  END
  </code></pre>
  
  <p>In CASE  if we write any condition we can write it by using WHEN...THEN.</p>
  
  <p>SO, Could you tell me how many number of times we can write WHEN... THEN condition  in one CASE.
  is their any limit to write WHEN....THEN Condition in one CASE.</p>
  
  <p>Thanks for your reply.
  Actually I got the answer of my question.
  I got the answer of My question.</p>
  
  <p>Actually we can write only 255 comparisons in one CASE.
  Each  WHEN...THEN  clause is considered 2 comparisons.</p>
  
  <p>we can write 255 comparisons in one CASE statement.
  Each WHEN...THEN clause is considered 2 comparisons.</p>
  
  <p>SAME LIMIT IS APPLIED TO DECODE.</p>
  
  <p>The maximum number of arguments in DECODE  function is 255.
  This includes  :
  EXPRESSION,SEARCH and RESULT arguments. </p>