1
I have the following value in an Oracle query.
SELECT '3.0.' FROM DUAL
I’d like you to return only 3.0 and remove the Last Point (.)
I tried to use the REGEXP_REPLACE thus:
SELECT REGEXP_REPLACE('3.0.','(.){2,.}','') FROM DUAL
But it didn’t work. You can help me?
Trim does not remove the spaces you have in the text?
– adventistaam
According to the documentation, you can specify what will be removed. If you do not specify, it removes spaces.
– mutlei
That’s right. Thank you very much!
– adventistaam