SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to store double data type number in Oracle table

384077Jun 26 2003 — edited Jul 3 2003

The double data type both in Java and C are capable of storing numbers up to
1.7976931348623158e+308 values.

I am trying to find a matching data type in Oracle, but the maximum number that I am capable to use is around 1E+125 using the NUMBER or FLOAT data types.

Is there a way to use numbers with the magnitude mentioned above? I mean to work with such numbers not just store them is a varchar column. If so what is the data type I should use?

Thanks,

Tal (otal@mercury.co.il).

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2003

Added on Jun 26 2003

2 comments

985 views