title: Oracle sql query with all mandatory values in where condition
body: <p>I want to write one select query in ORACLE which will return records only if all values given in where condition exists. E.g.</p>
  
  <pre><code>select * from emp where empid in (7521,7566,7698)
  </code></pre>
  
  <p>Now I want to write this query so that it should return value ONLY when all 3 empid exists.  It will be like AND condition i.e. empid = 7521 and empid = 7566 and empid = 7698.  If any one value does not exist then this query should not fetch any row.</p>