title: Oracle : merge two rows values into one row with new column names
body: <p>The version I'm using is Oracle database 12c.</p>
  
  <pre><code>select id,currency_code,currency_classification_code,amount from table;
  </code></pre>
  
  <p>DATA :</p>
  
  <pre><code>id   currency_code    currency_classification_code    Amount
  1    USD              Reporting                       111111
  1    AUD              BASE                            222222
  </code></pre>
  
  <p>Expected result :</p>
  
  <pre><code>id   Amt_in_base_curncy  base_curncy_code  Amt_in_rptng_curncy rptng_curncy_code
  1    222222              AUD               111111              USD
  </code></pre>
  
  <p>I want the data in the above format , by creating four new columns.</p>
  
  <p>please let me know if you need more details.</p>
  
  <p>Please help.</p>