db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-20) Oracle FLOAT and DOUBLE type mappings have zero scale
Date Fri, 30 Sep 2005 13:43:49 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-20?page=comments#action_12330957 ] 

Thomas Dudziak commented on DDLUTILS-20:
----------------------------------------

Actually, this is not the case. If you read the paragraph "Floating-Point Numbers" below the
table then you'll see that the scale parameter is not applicable to floating point numbers.
As per Oracle 8.1.7 spec, page 2-11:

"NUMBER is a floating-point number with decimal precision 38. Note that a scale value is not
applicable for floating-point numbers."

I refrained from using the ANSI datatypes until I have a Oracle 8 database to test against
(is in the works).

> Oracle FLOAT and DOUBLE type mappings have zero scale
> -----------------------------------------------------
>
>          Key: DDLUTILS-20
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-20
>      Project: DdlUtils
>         Type: Bug
>     Reporter: Richard Bounds
>     Assignee: Thomas Dudziak

>
> In Oracle8Platform, the types FLOAT and DOUBLE are mapped to NUMBER(38). According to
Oracle's docs, this type has zero scale. It looks like floating point numbers should be specified
either as just NUMBER or FLOAT(n). See:
> http://oraclelon1.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#g196646

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message