title: divisor is equal to zero
body: <p>i have the following data but in query i got the zero problem in division by zero. so i want the output as given below in two forms.</p>
  
  <pre><code>drop table t;
  
  create table t (id number(9), val1 number(9), val2 number(9));
  insert into t values (1,23,2);
  insert into t values (2,0,4);
  insert into t values (3,7,4);
  insert into t values (4,0,3);
  insert into t values (5,4,6);
  </code></pre>
  
  <p>select sqrt(val2*val1)/val1  from t ;</p>
  
  <p>SQL> /
  ERROR:
  ORA-01476: divisor is equal to zero</p>
  
  <p>expected reults</p>
  
  <p>in two forms
  first query
  like this </p>
  
  <pre><code>        ID SQRT(VAL2*VAL1)/VAL1
  ---------- --------------------
           1           .294883912
           2                    0
           3           .755928946
           4                    0
           5           1.22474487
  </code></pre>
  
  <p>second query
  like this</p>
  
  <pre><code>       ID SQRT(VAL2*VAL1)/VAL1
  ---------- --------------------
           1           .294883912
           3           .755928946
           5           1.22474487
  </code></pre>