What column type in Oracle can take full range of java double values

What column type in Oracle 10g can be used to store any value of java double up to and including Double.MAX_VALUE and Double.MIN_VALUE?

Answers


From the Oracle SQL Reference:

The NUMBER datatype stores zero as well as positive and negative fixed numbers with absolute values from 1.0 x 10^-130 to (but not including) 1.0 x 10^126.

It looks like you may need BINARY_DOUBLE:

Maximum positive finite value: 1.79769313486231E+308

Minimum positive finite value: 2.22507485850720E-308


Need Your Help

Next Button on Java DB Program

java nullpointerexception awt resultset javadb

I'm trying to create a simple app in Java. It is like a contact list with a few functions such as next, previous, first, and last buttons. I wrote some code for the "next" button. My program runs but

sp_executesql output parameter incorrect value

sql-server entity-framework-6

I'm getting different result for outputParam from fallowing two queries. The first one is generated by entity framework and it gives 0 for outputParam. For the second result is 5.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.