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;