Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number format

ronald_2017Dec 6 2024 — edited Dec 6 2024

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

This post has been answered by BluShadow on Dec 9 2024
Jump to Answer
Comments
Post Details
Added on Dec 6 2024
7 comments
500 views