title: Oracle Substring after specific character
body: <p>I already found out I need to use substr/instr or regex but with reading the documentation about those, I cant get it done...
  I am here on Oracle 11.2.</p>
  
  <p>So here is what I have.
  A list of Strings like:</p>
  
  <pre><code>743H5-34L-56
  123HD34-7L
  12HSS-34R
  23Z67-4R-C23
  </code></pre>
  
  <p>What I need is the number (length 1 or 2) after the first '-' until there comes a 'L' or 'R'.</p>
  
  <p>Has anybody some advice?</p>