title: How to transpose a table from columns to rows in Oracle sql
body: <p>I have a table in sql which has a number of columns with the same type of data each column. I would like to transpose the table's columns into rows so that all of the data appears in 1 column. An example of the type of table I am talking about:</p>
  
  <pre><code>ID    DATE    TEST_1    TEST_2    TEST_3
  ----------------------------------------
  1     1jan12    98        66       77
  2     2jan12    75        89       72
  </code></pre>
  
  <p>Into:</p>
  
  <pre><code>ID    DATE        TEST       SCORE
  -----------------------------------
  1     1jan12      TEST_1      98
  1     1jan12      TEST_2      66
  1     1jan12      TEST_3      77
  2     2jan12      TEST_1      75
  2     2jan12      TEST_2      89
  2     2jan12      TEST_3      72
  </code></pre>
  
  <p>Thanks in advance for any suggestions or directions!</p>