Home>

I have a question about the behavior of the TO_CHAR function in Oracle.

I want to output NUMBER type 0.01 on the table to the string 0.01 using the TO_CHAR function.

However, the result is as follows.
【SQL】
SELECT TO_CHAR (0.01) FROM DUAL;

[Result]
.01

How can I output 0.01 as a string?