title: Generating the unique sets of attributes into a new table?
body: <p>I currently need to make a table that holds the unique sets of attributes for another table. That is, I have a table that looks like this:</p>
  
  <p><code>Table A : columns = col 1, col2, col3, col4, col5</code></p>
  
  <p>And I need to produce this:</p>
  
  <pre><code>Table B : columns = columnName, value
  col 1, col1attribute1
  col 1, col1attribute2
  col 1, col1attribute3
  col 2, col2attribute1
  col 3, col3attribute1
  col 3, col3attribute2
  </code></pre>
  
  <p>Is there an easy way to do this with (PL)SQL alone? It seems simple enough if I do it programatically in Java, but ideally I'd like an sql-only solution if possible.</p>