Does anyone know what precision Oracle uses in arithmatic?

From: Raymond Velez <rvele_at_ctp.com>
Date: 14 Feb 1995 16:40:06 -0500
Message-ID: <3hr7vm$hj4_at_toon.ctp.com>


select

        (old_qty / (qty1/qty2)) * price,
from
 blah blah

I was wondering what the precision of the first parenthesized statement will be. I am hoping that it uses out the fifteenth decimal place precision. That is what most C code uses. Any input would be appreciated.

                        -Ray Velez

-- 

((((((((((((((((((((((((((((((((((((((((*))))))))))))))))))))))))))))))))))))))
rvele_at_ctp.com | Cambridge Technology Partners | Raymond Velez | 304 Vassar St, Cambridge, MA | WORK: (617)374-8399
((((((((((((((((((((((((((((((((((((((((*))))))))))))))))))))))))))))))))))))))
Received on Tue Feb 14 1995 - 22:40:06 CET

Original text of this message