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;


You might Like

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