Is there any DOUBLE Data Type in Oracle?
if so pls tell me
if not what is the alternate?
Printable View
Is there any DOUBLE Data Type in Oracle?
if so pls tell me
if not what is the alternate?
Hi !!
You can define a column with datatype "Double Precision" in Oracle .. but by default Oracle is treating it as its "Float" datatype.... Double Precision is just there for the ANSI support.
create table mna (fi double precision);
SQL> desc mna
Name Null? Type
----------------------------------------- -------- ----------------------------
FI FLOAT(126)
Hope it will be helpful.
Regards
Nadeem
From the SQL manual:So I don't think you're doing any better than with NUMBER.Quote:
The FLOAT datatype is a floating-point number with a binary precision b. The default precision for this datatype is 126 binary, or 38 decimal.
The DOUBLE PRECISION datatype is a floating-point number with binary precision 126.