title: Is there a way to denormalize data in the resultset of an Oracle SQL query
body: <p>I have table Students as follows:</p>
  
  <pre><code>SNO    NAME   SUBJECT   MARKS
  -----------------------------    
  1      HARWI   HINDI     75
  2      SHWETA  ENGLISH   80
  3      RUDRA   MATHS     90
  4      HARWI   MATHS     60
  5      MANVI   GK        89
  6      RUDRA   HINDI     98
  7      SHWETA  MATHS     67
  </code></pre>
  
  <p>I need output like this:</p>
  
  <pre><code>1   HARWI     HINDI   75
                MATHS   60
  2   MANVI     GK      89
  3   RUDRA     HINDI   98
                MATHS   90
  4   SHWETA    ENGLISH 80
                MATHS   67
  </code></pre>
  
  <p>I DO NOT WANT TO USE concatenation operator <code>||</code></p>
  
  <p>Are there standard functions in Oracle which can help me achieve this result set?</p>