title: Oracle query for REGEX_LIKE for list of strings
body: <p>am new to regex, I need the following to 
  a sql query to extract rows with columns to match any or all 4 strings but nothing beyond those 4 strings</p>
  
  <p>e.g </p>
  
  <p>row1 field has: abc, def, ghi, xyz</p>
  
  <p>row2 field has: abc, ghi, xyz</p>
  
  <p>row3 field has: ghi; abc, </p>
  
  <p>row4 field has: poi; iop</p>
  
  <p>lets say we need all with value "xyz" and/or "abc" and/or "ghi"</p>
  
  <p>it should only return row2 and row3  </p>
  
  <p>I tried
  select * from emp where REGEX_LIKE(empname, '. * (abc|ghi|xyz).*$') </p>
  
  <p>but with little luck, it return all the above rows since am not able to negate those with additional patters. 
  Please advise</p>