Enrique February 2016
when choose Float or Number types in Oracle
I m reading some table in Oracle and i m looking like some times they are using "FLOAT" type or "NUMBER" for practicaly the same value
CREATE TABLE sensor_A
( sen_id NUMBER,
sen_Rating NUMBER, --here i m wating something like 12,9984
sen_value FLOAT(64), -- here im waiting too something like 0,83387
so what should i choose Float or Number when i want to save a number with decimals , is there a case where is better use one or other?
Thanks in advance, Enrique
Rahul Tripathi February 2016
FLOAT is just an alias for NUMBER datatype in Oracle. So you can choose any of them, as they are just the synonym of each other.
A subtype of the NUMBER datatype having precision p. A FLOAT value is
represented internally as NUMBER. The precision p can range from 1 to
126 binary digits. A FLOAT value requires from 1 to 22 bytes.
Asked in February 2016
Viewed 3,460 times Voted 4 Answered 1 times
Leave an answer
Quote of the day: live life
Devs Planet © all rights reserved