I have the following value in an Oracle query.
SELECT '3.0.' FROM DUAL
I would like it to return only 3.0 and remove the Last Point (.)
I tried using REGEXP_REPLACE like this:
SELECT REGEXP_REPLACE('3.0.','(.){2,.}','') FROM DUAL
But it did not work. Can you help me?