title: combine multiple rows into a single row in Oracle?
body: <p>I have 3 column in my test table like</p>
  
  <pre><code>ID | m_id    | S_m_id                                 
  ---------- --------------
  1  |  1      |    1                  
  1  |  2      |    3                  
  1  |  3      |    4                  
  1  |  5      |    6                  
  2  |  1      |    1                  
  2  |  2      |    3                  
  2  |  3      |    4                  
  3  |  5      |    6
  </code></pre>
  
  <p>I want to merge column 2 and 3 based on column 1 into one single row. And the result should be like</p>
  
  <pre><code>ID | merge_id                                 
  ---------- --------------
  1  |  1,1;2,3;3,4;5,6                  
  2  |  1,1;2,3;3,4                  
  3  |  5,6       
  </code></pre>