title: How to remove text following a dash in oracle?
body: <p>I was looking at </p>
  
  <pre><code>replace('ABC-DEF', '-') 
  </code></pre>
  
  <p>and </p>
  
  <pre><code>regexp_replace('ABC-DEF', '-$') 
  </code></pre>
  
  <p>to help me remove all characters after a dash but I haven't been able to find a good function or expression that matches what I want to do. What is a good oracle expression that does this?</p>
  
  <pre><code>ABC-DEF =&gt; ABC
  </code></pre>