title: How to select columns conditionally in Oracle?
body: <p>I want to select a data from <strong>Oracle</strong> . However I have a column - <code>CHILD_IDN</code> -  that decides which column is right for me . If the  column is having an idn then I need to pick <code>CHILD</code> from the table else by default I should pick the <code>PARENT</code> . MSSQL allows a simple CASE statement to work . 
  But what about Oracle ? Is there a Oracle vs MSSQL compatible query for this ? I think its a non - normalized data hence need advice .</p>
  
  <p>For example</p>
  
  <pre><code>TableA
  
  1    PARENT  CHILD_IDN CHILD
  2    Okay 
  3    Cool    1         PickMe1 
  4    Fine
  5    Test
  6    Bar     2         Pickme2
  7    Hello   
  
  
  Now the result expected is 
  
  Okay 
  PickMe1
  Fine
  Test
  Pickme2
  Hellow
  </code></pre>