Hello can anyone help me with the following issue.
Details are below;
Platform used:
Oracle Express edition 11g.
sqlplus
Question:
1. How to create and access FLOAT 64 value column/Data in the database table ?
Summary:
I have used sQL Query to create a table,
Here it goes like this.
CREATE TABLE SAMPLE
(
"COLUMN1" NUMBER(*,6) DEFAULT 0,
"COLUMN2" NUMBER(*,6) DEFAULT 0,
"COLUMN3" BINARY_DOUBLE DEFAULT 0,
"COLUMN4" BINARY_DOUBLE DEFAULT 0,
)
Issue:
I am not able to store the Max value of FLOAT 64 in the table.
Float 64s max value is = 1.7E+308 (15 digits)
Where as the Column 3 and 4 allows only 3.1+125, which is max value for NUMBER data type.
Please let me know how to store and retrieve FLOAT 64s max value 1.7E+308 (15 digits) in database.
Thanks in advance