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