title: NOT EQUAL operator != not working as expected in Oracle
body: <p>I have made a new column in my database table:</p>
  
  <pre><code>alter table TABLE add (COLUMN NUMBER(1));
  </code></pre>
  
  <p>Now I want to select all records where the value of column is not zero, either it’s some other number of empty (null)</p>
  
  <pre><code>SELECT * FROM TABLE WHERE COLUMN != 0;
  </code></pre>
  
  <p>And by default all columns have empty/null value as this column is recently added so it should return all records but doesn’t return any.</p>
  
  <p>But if a change the value for this column of a record to <code>0</code> and run below query it works fine.</p>
  
  <pre><code>SELECT * FROM TABLE WHERE COLUMN = 0;
  </code></pre>
  
  <p>Please help I want to select all records where the value is not <code>0</code>.</p>