title: REGEXP_SUBSTR get second match
body: <p>I have this <strong>String :</strong> </p>
  
  <pre><code>"Y::_~XXXXXX XXXXXX~MIGRATION~_~_~_~_~0~JOD50.000~USD257.43::JOD"
  </code></pre>
  
  <p>I wanted to get the list of currencies via <strong><code>Regex</code></strong>.</p>
  
  <p>So far, I can only get the first match using this query:</p>
  
  <pre><code>SELECT 
  REGEXP_SUBSTR('Y::_~XXXXXX XXXXXX~MIGRATION~_~_~_~_~0~JOD50.000~USD257.43::JOD','[a-zA-z]{3}$') 
  from dual;
  </code></pre>
  
  <p>Can you please help me get the second match which is USD?? Thanks. :D</p>
  
  <p>By the way, I am planning to use the <strong><code>Regex</code></strong> dynamically. </p>
  
  <p>So given any output of String, I wanted to get 3-length <strong>String :</strong>  either by occurence</p>
  
  <pre><code>"Y::_~XXXXXX XXXXXX~MIGRATION~_~_~_~_~0~JOD50.000~USD257.43::JOD"
  </code></pre>
  
  <blockquote>
    <p>JOD </p>
    
    <p>USD</p>
  </blockquote>