title: Floating point comparison in Oracle
body: <p>I have a query like</p>
  
  <pre><code>SELECT
      some_field,
      SUM(float_field)
  FROM
      some_table
  GROUP BY
      some_field
  HAVING
      SUM(float_field) &lt;&gt; 0
  </code></pre>
  
  <p>Is it safe to use such way of comparison in Oracle or it is better to use something like</p>
  
  <pre><code>ABS(SUM(float_field)) &lt; PrecisionConstant
  </code></pre>
  
  <p>Just for case, float_field is not nullable field of FLOAT type</p>