title: Use Oracle INSTR function to search for multiple strings
body: <p>In Oracle/PLSQL, the <code>instr</code> function returns the location of a sub-string in a string.</p>
  
  <p>If the sub-string is not found, then <code>instr</code> will return <code>0</code>.</p>
  
  <p>I want to search multiple sub-strings in a string and return the first non-zero value. This can be achieved using <code>regexp_instr</code>, but I'd like a non-<code>regexp_</code> solution.</p>
  
  <p><b>Example:</b></p>
  
  <pre><code>regexp_instr('500 Oracle Parkway, Redwood Shores, CA','(Apple|Park|Shores)')
  </code></pre>
  
  <p>should return 12 (the location of 'Park').</p>