title: oracle | rename columns with case
body: <p>I have a table defined as this:</p>
  
  <pre><code>CREATE TABLE GENERAL_STATISTICS.PPLP_LOAD_GENSTAT3
  (
    NAME    VARCHAR2(100 BYTE),
    START_TIME   DATE,
    END_TIME     DATE,
    ROWS_LOADED  VARCHAR2(100 BYTE)
  )
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/FTgMU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FTgMU.png" alt="enter image description here"></a></p>
  
  <p>Well I want to rename PPLP IMPORT DATA to something else eg 'Report1'</p>
  
  <p>with case statement but it does not work.</p>
  
  <pre><code>SELECT PPLP_NAME,
    (CASE
       WHEN PPLP_NAME='PPLP IMPORT DATA' THEN 'BSCS_PPL_IMP_INVOICE'
       WHEN PPLP_NAME='PPLP IMPORT DATA FOR RERUN' THEN 'BSCS_PPL_IMP_USAGE_RERUN'
    END)
  FROM  PPLP_LOAD_GENSTAT3
  </code></pre>