title: Oracle Sql: Case When and Decode
body: <p>I'm getting the error "Missing Keyword" for this query.</p>
  
  <p>The purpose of this query is to find the Zone designation. Example: If COLUMN1 is 'Lab', and COLUMN2 is 'Reg1', then create a new column called CollectionZone with the text of 'Zone1'. Or if COLUMN1 is 'Lab', and COLUMN2 is 'Reg2', then create a new column called CollectionZone with the text of 'Zone2'. Sequence will continue for Reg3, Zone 3, etc. </p>
  
  <p>I am uncertain of why there is an error message. Perhaps the error is because I don't know how to End the Case statement. Any thoughts about how to change the query? Thanks!</p>
  
  <pre><code>Select
  Case When COLUMN1 In ('Lab') Then
  Decode (COLUMN2, 'Reg1', 'Zone1', 'Reg2', 'Zone2', 'DefaultZone') CollectionZone
  From Test_Table
  ;
  </code></pre>