Re: Oracle DataType equivalent to SQL double

On Thu, 08 Sep 2005 11:04:35 -0700, sunny076 interested us by writing:

> Hi,
>
>
> Here is the syntax I used:
>
> CREATE TABLE TEST_DOUBLE(F1 FLOAT(126));
>
> INSERT INTO TEST_DOUBLE (1.02108663734188E+305);
>
> The error is "ORA-01426: numeric overflow".
>
> I am having Oracle 9i.
>
> I would appreciate if anyone can help me.
>
> Sunny

Move up to Oracle Database 10g and use BINARY_FLOAT and BINARY_DOUBLE.

The technology you want does not exist in Oracle9i. Sheesh.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***