Hello,
in my table I want to store strings converted to numbers, e.g. 1, 1.0, 1.1.
CREATE TABLE ."MY_TABLE"
( "COL1" NUMBER
) ;
insent into my_table (col1) values to_number('1');
insent into my_table (col1) values to_number('1.0');
insent into my_table (col1) values to_number('1.1');
After this in SQL Developer I see values
1,
1,
1.1
How to store in column numbers with ending zeros like 1.0?