Hello All,
Is there any option to remove the decimal point sign at end of the number without using rtrim? I want to use the following format except for integers. Because, it remains the decimal point sign at the end of the integers.
SQL> select to_char('0', 'FM999999990D9999') from dual;
TO_CHAR('0','FM
---------------
0,
Thanks in advance