title: How to Select a substring in Oracle SQL up to a specific character from right?
body: <p>I have string like below,</p>
  
  <blockquote>
    <p>ABC_blahblahblah<br/>
    DEFGH_moreblahblahblah<br/>
    IJKLMNOP_moremoremoremore.<br/></p>
  </blockquote>
  
  <p>I need result like,</p>
  
  <blockquote>
    <p>blahblahblah<br/>
    moreblahblahblah<br/>
    moremoremoremore in oracle.</p>
  </blockquote>
  
  <pre><code>SELECT NVL(SUBSTR('ABC_blah', 0, INSTR('ABC_blah', '_')-1), 'ABC_blah') AS output
    FROM DUAL.
  </code></pre>
  
  <p>Above query gives only from LEFT HAND SIDE, But how can I get from RIGHT HAND SIDE.</p>