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

select REGEXP_REPLACE ('Annapurna1@ Poojari675&^','(W|d)','') from dual;

actually output is AnnapurnaPoojari but i need as Annapurna Poojari

Advertisement

Answer

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

select REGEXP_REPLACE('Annapurna1@ Poojari675&^', '([^a-zA-Z ])', '')
from dual;
User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement