title: oracle regular expression to extract decimal numbers from string
body: <p>I am trying to extract decimal numbers from a random string. How to do this using regex_replace function? Optionally i want to retain negative sign for negative integers.</p>
  
  <p>example: </p>
  
  <p>input: </p>
  
  <pre><code>'text abc023.46'
   '-123.12abc'
  </code></pre>
  
  <p>output: </p>
  
  <pre><code>023.46
  -123.12
  </code></pre>