title: Oracle INSTR backward in Oracle SQL
body: <p>I am trying to find a way in oracle SQL to take all the text after the 1st "/" FROM THE RIGHT to the 4th "/".  I need to do this in one SQL statement..</p>
  
  <pre><code>table name: access_log
  col name: download
  value: Download file:/webdocs/data/groupXXX/case/03_28_54_9_0000011856.pdf
  </code></pre>
  
  <p>I am trying to end up with </p>
  
  <pre><code>case
  </code></pre>
  
  <p>then a count of how many matches?  can this be done?</p>