I am not familiar with regular expressions. My requirement is very simple. How to remove '%' from a string.
i.e. 12.56% to 12.56
'dkdk%kkd' to 'dkdkkkd'
The % sign will appear only once and it can appear anywhere in the string.
PS: I am using this as a format string. Java program will apply this regular expression to string. So I can't use Oracle functions like REGEXP_REPLACE, although we can use this to test our format string.