title: distinct values from multiple fields within one table ORACLE SQL
body: <p>How can I get distinct values from multiple fields within one table with just one request.</p>
  
  <p><strong>Option 1</strong></p>
  
  <pre><code>SELECT WM_CONCAT(DISTINCT(FIELD1)) FIELD1S,WM_CONCAT(DISTINCT(FIELD2)) FIELD2S,..FIELD10S
    FROM TABLE;
  </code></pre>
  
  <p>WM_CONCAT is LIMITED</p>
  
  <p><strong>Option 2</strong></p>
  
  <pre><code>select DISTINCT(FIELD1) FIELDVALUE, 'FIELD1' FIELDNAME
         FROM TABLE
  UNION
  select DISTINCT(FIELD2) FIELDVALUE, 'FIELD2' FIELDNAME
         FROM TABLE
  ... FIELD 10
  </code></pre>
  
  <p>is just too slow</p>