title: How to concat two column with '-' seperator in PL/SQL
body: <p>I just want to concat two columns with seperator '-'.</p>
  
  <p>These are the two columns, want to concat.</p>
  
  <p><img src="https://i.stack.imgur.com/uthcT.png" alt="enter image description here"></p>
  
  <p>I am using this query to concat them </p>
  
  <pre><code>select concat(amt,endamt)as amount from mstcatrule
  </code></pre>
  
  <p>and it is giving me result this </p>
  
  <p><img src="https://i.stack.imgur.com/jWFgn.png" alt="enter image description here"></p>
  
  <p>But I Want that data of 2 columns should be sepearted by '-'</p>
  
  <p>RESULT I WANT IS :</p>
  
  <pre><code>AMOUNT
  0-0
  100-99999999999
  100-500
  </code></pre>