title: Oracle regular expression match multiple part of a column value
body: <p>Imagine that I have the below database table with 2 columns</p>
  <pre><code>row1  AA.B.HOME.CCC.N111.DDDD
  row2  RRR.BCD.HOME.CCC.N222.DDDD
  row3  AAAA.B.WORK.EEEEE.N111.GGGGG
  row4  AA.B.WORK.FFFF.N222.TT
  </code></pre>
  <p>I need a query that given &quot;HOME&quot; and &quot;111&quot; in input, need to return only &quot;row1&quot; result.</p>
  <p>The number of dots is fixed, but each block can be variable in length.
  The &quot;N111&quot; block always start with N.</p>
  <p>Is it possible with an Oracle regular expression? How heavy it will be if there are thousand rows?</p>