title: Oracle: Regular expression for dot
body: <p>For example, I have a table "example" which has a column "col1" with string like below</p>
  
  <pre><code>some example text here x2.0.3-a abc
  some other example text 1.5 abc
  another example text 0.1.4 mnp
  some other example text  abc
  another example text mnp
  </code></pre>
  
  <p>I want to select those rows that matches a regular expression. I want the regular expression something like this</p>
  
  <p><code>any string.any string.any string space abc/mnp</code>  or <code>any string.any string space abc/mnp</code> that is the regular expression should match two or three dots, before and after of each dot there should be at least one string(char/number/special chars) and then a single space and then at the end either <code>abc/mnp</code>. What will be the regular expression and sql query for this?</p>