Variable float with 2-digit precision after the comma in sql oracle

0

How do I create a float variable with 2-digit precision after the comma in a table in SQL / Oracle.

Thank you in advance.

    
asked by anonymous 06.06.2017 / 15:36

1 answer

0

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.

    
06.06.2017 / 15:43