title: How do I return multiple column values as new rows in Oracle 10g?
body: <p>I have a table where multiple account numbers are associated with different IDs(DR_NAME). Each account could have as few as 0 accounts, and as many as 16.  I believe UNPIVOT would work, but I'm on Oracle 10g, which does not support this.  </p>
  
  <pre><code>DR_NAME   ACCT1   ACCT2   ACCT3   ACC4  
  ======================================
  SMITH     1234
  JONES     5678    2541    2547
  MARK      NULL    
  WARD      8754    6547
  </code></pre>
  
  <p>I want to display a new line for each name with only 1 account number per line</p>
  
  <pre><code>DR_NAME   ACCT
  ==============
  SMITH     1234
  JONES     5678
  JONES     2541
  JONES     2547
  MARK      NULL
  WARD      8754
  WARD      6547
  </code></pre>