Remove Special Character and Extra Space From a String ORACLE/PLSQL

Remove Special Character and Extra Space From a String ORACLE/PLSQL

• Removing special character using REGEXP:

SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL;

• Remove extra spaces between string using REGEXP:

SELECT REGEXP_REPLACE ('Vikas                      Pandey from              Delhi', '[[:blank:]]+', ' ') FROM DUAL;

Related Post:

•  How to Remove New line from a String Using PL/SQL/ORACLE