Skip to content
Advertisement

how remove special character and digits from a string but ignore white spaces

i tried to remove special characters and numeric number from string of sentence but it should ignore white spaces if there is a more than one it should replace with one

SQL developer,oracle 11g

actually output is AnnapurnaPoojari but i need as Annapurna Poojari

Advertisement

Answer

You can be more explicit about the characters you want to keep:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement