title: REGEXP_LIKE QUERY IN ORACLE DB
body: <p>I need to currently match <code>00000012345</code> and <code>12345</code> in my <code>DB</code> search query.
  I am currently using following query:</p>
  
  <pre><code>SELECT * 
  FROM BPP.CHECK_REGISTER 
  WHERE CHECK_NO like CONCAT('%',:checkNum)
  </code></pre>
  
  <p>for searching but here <code>%</code> can mean any character other than <code>0</code> hence I have replaced this query with following:</p>
  
  <pre><code>SELECT * 
  FROM BPP.CHECK_REGISTER 
  WHERE REGEXP_LIKE (CHECK_NO,'^(0*12345)$')
  </code></pre>
  
  <p>but in this query I don't want to mention <code>12345</code> but mention it as a user entered parameter like the first query <code>:checkNum</code></p>
  
  <p>How do I rephrase the <code>REGEXP_LIKE</code> condition with only 2 arguments with user input <code>:checkNum</code> as oracle db allows only a maximum of 2 arguments. (another problem)</p>