title: Concatenate multiple columns into one column (~) separated
body: <p>Query</p>
  
  <pre><code>select DISTINCT(a.col1),b.col2
  FROM tab1 a RIGHT OUTER JOIN  tab2 b
  ON a.tab1_id=b.tab2_id
  WHERE
  a.tab1_id=105
  </code></pre>
  
  <p>Getting output as</p>
  
  <pre><code>col1           col2
  ______________________
  A               val1
  A               val2
  </code></pre>
  
  <p>I want to concatenate the above result in one value <code>~</code> separated</p>
  
  <p>eg.  <code>A~val1~val2</code></p>
  
  <p>Please guide</p>