title: oracle equivalent of patindex and instr function with wild card characters
body: <p>is there an oracle equivalent of <code>patindex</code>? from my search, the only function that is close to <code>patindex</code> is oracle's <code>instr</code> function but it does not support wild card.</p>
  
  <p>what is the oracle equivalent of the following query?</p>
  
  <pre><code>select patindex('%[^0]%','00194505022') 
  </code></pre>
  
  <p>edit: i found out <code>regexp_instr</code> have the similar function as <code>patindex</code>.</p>