title: Single SQL SELECT Returning multiple rows from one table row
body: <p>We have a table which is of the form:</p>
  
  <pre><code>ID,Value1,Value2,Value3
  1,2,3,4
  </code></pre>
  
  <p>We need to transform this into.</p>
  
  <pre><code>ID,Name,Value
  1,'Value1',2
  1,'Value2',3
  1,'Value3',4
  </code></pre>
  
  <p>Is there a clever way of doing this in one SELECT statement (i.e without UNIONs)?  The column names Value1,Value2 and Value3 are fixed and constant.</p>
  
  <p>The database is oracle 9i.</p>