title: How to extract the number from a string using Oracle?
body: <p>I have a string as follows:  <code>first, last (123456)</code> the expected result should be <code>123456</code>. Could someone help me in which direction should I proceed using Oracle?</p>