Oracle DataTypes - DOUBLE?

[pratap_surisoft]

Is there any DOUBLE Data Type in Oracle?
if so pls tell me
if not what is the alternate?

[mnakhtar]

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

[DaPi]

From the SQL manual:

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.

So I don't think you're doing any better than with NUMBER.