CREATE TABLE table_name_2 (significand__fraction_field_ VARCHAR2, value VARCHAR2)

What's the Significant of a value 1.0?
SELECT significand__fraction_field_ FROM table_name_2 WHERE value = "1.0"
SELECT "significand__fraction_field_" FROM "table_name_2" WHERE "1.0" = "value"