title: OR clause in Regular Expression
body: <p>I am trying to validate some phone number which may come in the following two forms</p>
  
  <p>123.231.457 or 011.44.321.326589</p>
  
  <p>I was trying to use REGEXP_LIKE to validate it. However I want to know if we can use  OR clause in regexp_like ? </p>
  
  <p>Here is my code</p>
  
  <pre><code>select count(1) digit_count
  from dual 
  where regexp_like(l_phone_no,'[0-9]{3}.[0-9]{3}.[0-9]{4}');
  </code></pre>
  
  <p>which works fine for phone number of the form <strong>123.231.4575</strong> . </p>