By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT rtrim('100.100', '.') FROM dual;
| RTRIM('100.100','.') |
|---|
| 100.100 |
SELECT rtrim('100.', '.') FROM dual
| RTRIM('100.','.') |
|---|
| 100 |
| RTRIM('100.100','.') |
|---|
| 100.100 |
| RTRIM('100.','.') |
|---|
| 100 |