Hi All,
how can i remove the spaces by regular expression from string only between numbers but if letters no need to remove spaces.
if the string has numbers like this
12 45
remove the white space but in charachter no need to remove white space.
select (' Hello to oracle 11 . 2. 1 ') from dual,
select (' Hello to oracle 11 2 1 ') from dual,
the expected reults is
Hello to oracle 11.2.1
Hello to oracle 1121
帖子经 Ayham编辑过