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