Oracle 10g Float Format

Question

How can I return from a float / decimal value with the following:

SELECT 210 
  FROM DUAL

... receive:

210.00 

... instead 210?

Using pl / sql oracle 10g

Answer 1

SELECT TO_CHAR(210, '999.99') FROM dual;

Additional to_char formats are here .

Answer 2

Using:

SELECT CAST(210 AS NUMBER(3,2))
  FROM DUAL

... to get the value as a numeric data type. TO_CHARwill work with the filter, but returns the result as a string.

Link:

• Cast
• TO_CHAR

Answer 3

to_char, , . to_char (210.00, '000.00') . Google " ", .

Edit Find "Number Format Elements" here .