Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle DataType equivalent to SQL double
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 Received on Thu Sep 08 2005 - 13:04:35 CDT