How do I create a float variable with 2-digit precision after the comma in a table in SQL / Oracle.
Thank you in advance.
How do I create a float variable with 2-digit precision after the comma in a table in SQL / Oracle.
Thank you in advance.
In this case you could use decimal
, as follows:
create table t (a decimal(10,2));
The first number represents the precision, which can range from 1-31, it represents the total number of digits you can have in the number.
The second represents the scale, in this case the amount of digits that can come after the comma.