-
Oracle DataTypes - DOUBLE?
Is there any DOUBLE Data Type in Oracle?
if so pls tell me
if not what is the alternate?
Pratap
-
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:
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|