Formatting

PL/SQL - How to Remove Trailing Zeros but Keep Leading Zero

WITH T AS ( SELECT 100 AS EXAMPLE FROM DUAL UNION SELECT 98.336 AS EXAMPLE FROM DUAL UNION SELECT 25 AS EXAMPLE FROM DUAL ) SELECT EXAMPLE / 100 AS EXAMPLE_1, TO_CHAR(EXAMPLE / 100) AS EXAMPLE_2, RTRIM(TO_CHAR(EXAMPLE / 100, 'FM0.999999999999'), '.') AS EXAMPLE_3 FROM T; Thanks to Oracle Community