title: How to use REGEXP_SUBSTR to extract the last string?
body: <p>I want to extract a last string of sentence. For example</p>
  
  <pre><code>input  - 'SURGICAL INC (SKUMAR) (1058585_BI_SF)'
  output - 1058585_BI_SF
  
  input  - 'MEDICAL, ABC(854567_BI_SF)'
  output - 854567_BI_SF
  </code></pre>
  
  <p>How do I accomplish this using regular expressions in Oracle?</p>