title: Oracle: Get All Rows Except One
body: <p>I am stuck with a simple query. What i want is to get all rows except one Kindly have a look at the following data.</p>
  
  <pre><code>COL_A   COL_B
  B       D
  B       (null)
  B       C
  G       D
  G       (null)
  G       C
  </code></pre>
  
  <p>I want to get all rows except but <strong>B C</strong>. Kindly have a look at the <a href="http://sqlfiddle.com/#!4/33a62/6" rel="nofollow">sqlfiddle</a></p>
  
  <p>I have tried to get the rows by anding <code>col_A &lt;&gt; 'B' and col_B &lt;&gt; 'C'</code> but it's not anding the operation. Your help will be much appreciated.</p>
  
  <p>Thanks</p>