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: Copy CodeCopiedUse a different BrowserSELECT REGEXP_REPLACE ('Vikas Pandey from Delhi', '[[:blank:]]+', ' ')…
