title: ORA-01476: "divisor is equal to zero" for SQL query (Oracle 10g)
body: <p>I'm creating an SQL Query under oracle 10g, the result should give me something like that :</p>
  
  <pre><code>----------------------------------------------------------------------------------
  TEXT         VALUE1        VALUE2          VALUE3               VALUE4
  ---------------------------------------------------------------------------------
  TEXT1        8795           5684        value1-value2          value3/value2*100
  TEXT2        235             568            ...                   ...
  TEXT3        125             23             ...                   ...
  TEXT4        789             58             ...                   ...
  TEXTN         0               0             ...                   ...
  </code></pre>
  
  <p>when i try to calculate VALUE4 column i get this error :</p>
  
  <pre><code>ORA-01476: le diviseur est égal à zéro
  01476. 00000 -  "divisor is equal to zero"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>I tried <code>DECODE</code> function but i stil have the same error, it's the same for <code>CASE</code></p>
  
  <p><em>NB : VALUE1, VALUE2, VALUE3 and VALUE4 are calculated columns; VALUE1 = sum(col1)+sum(col2).. and so for other VALUE2 column.</em></p>
  
  <p>Thanks and regards </p>