title: CASE .. WHEN expression in Oracle SQL
body: <p>I have the table with 1 column and has following data</p>
  
  <pre><code>Status
  a1
  i
  t
  a2
  a3
  </code></pre>
  
  <p>I want to display the following result in my select query</p>
  
  <pre><code>Status| STATUSTEXT
  a1    | Active
  i     | Inactive
  t     | Terminated
  a2    | Active
  a3    | Active
  </code></pre>
  
  <p>One way I could think was using a Switch When expression in select query</p>
  
  <pre><code>SELECT
  status,
  CASE status 
  WHEN 'a1' THEN 'Active'
  WHEN 'a2' THEN 'Active'
  WHEN 'a3' THEN 'Active'
  WHEN 'i' THEN 'Inactive'
  WHEN 't' THEN 'Terminated'
  END AS StatusText
  FROM stage.tst
  </code></pre>
  
  <p>Is there any other way of doing this where I don't need to write <i><B>When expression 3 times for Active Status </B></i> and the entire active status can be checked in one single expression?</p>