title: Full Text search using oracle regex
body: <p>I am trying to use regexp_like() in oracle 11g to achieve text search.</p>
  
  <p>for example I have a table called posts where in title column if I have values</p>
  
  <pre><code>'How to create a new post with pictures and videos'
  'How to create a new post enter code here'
  </code></pre>
  
  <p>and if I write a query </p>
  
  <pre><code>select * from posts where regexp_like(title, '.*pictures.*|.*how.*|.*post.*', 'i')
  </code></pre>
  
  <p>It returns records having both titles where the second value does not have word pictures in it. I know its because I user '|' in the expression.</p>
  
  <p>What I want to achieve is It should return records <strong>only if all the words are present in the column in any order.</strong> Help me with the regex please</p>