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

Filtering DataGridView VB

vb.net filter

note: all column data is stored as nvarchar

RichTextBox with text filtering

c# winforms visual-studio-2008 filter richtextbox

How can I implement in richTextBox something like filter (connected e.g. with combobox) that'll be responsible for showing only lines containing selected word (filters)?