When using Oracle Database, you can use functions like TO_CHAR(number)
to return numbers as a string, formatted to two decimal places (or however many decimal places you require).
Or you can use functions like ROUND(number)
and TRUNC(number)
to round or truncate the number to your required number of decimal places.