title: How do you select all columns, plus the result of a CASE statement in oracle 11g?
body: <p>I want to select *, and not have to type out all individual columns, but I also want to include a custom column with a case statement.  I tried the following:</p>
  
  <pre><code>select *, (case when PRI_VAL = 1 then 'High'
                  when PRI_VAL = 2 then 'Med'
                  when PRI_VAL = 3 then 'Low'
            end) as PRIORITY
  from MYTABLE;
  </code></pre>
  
  <p>But it is complaining that</p>
  
  <pre><code>ORA-00923: FROM keyword not found where expected
  </code></pre>