Float variable with 2 digit accuracy after the comma in sql oracle

Asked

Viewed 401 times

0

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

From now on, thank you.

sql float oracle11g

1 answer

0


In that case you could use the decimal, as follows:

create table t (a decimal(10,2));

The first number represents the precision, which can vary from 1-31, it represents q total number of digits that can have in the number.

The second represents the scale, in case the number of digits that can come after the comma.

Browser other questions tagged sql float oracle11g

You are not signed in. Login or sign up in order to post.