Ontoor Solutions Pvt. Ltd.

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