title: perform or not perform a specific predicate in WHERE clause conditionally in SQL Oracle
body: <p>Is there a way in SQL Oracle to perform a predicate in where clause conditionally depending if a record exist in a specific table.</p>
  
  <p>Example</p>
  
  <pre><code>SELECT * FROM TABLE_A a, TABLE_B b, TABLE_C c
  WHERE a.personalID = B.personalId
        and b.companyID = c.companyID
  </code></pre>
  
  <p>When a specific company ID is NOT existing in Table_C then this part in where clause SHOULD not be perfomed as execute.</p>
  
  <pre><code>and b.companyID = c.companyID
  </code></pre>