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

SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; You might Like How to Remove New line from a String Using PL/SQL/ORACLE Read more