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

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

Pewview

  • Removing special character using REGEXP:
SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL;

Data view

  • Remove extra spaces between string using REGEXP:
SELECT REGEXP_REPLACE
 ('Vikas                      Pandey from              Delhi', '[[:blank:]]+', ' ')
 FROM DUAL;

Data view

You might Like

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


comments powered by Disqus