Oracle DataTypes - DOUBLE?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle DataTypes - DOUBLE?

  1. #1
    Join Date
    Mar 2004
    Location
    Bangalore
    Posts
    3

    Oracle DataTypes - DOUBLE?

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

  2. #2
    Join Date
    Jun 2003
    Location
    Saudi Arabia
    Posts
    5
    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

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
  •  



Click Here to Expand Forum to Full Width