![](https://blogs.ontoorsolutions.com/wp-content/uploads/2023/01/image-347.png)
- Removing special character using REGEXP:
SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL;
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2023/01/image-346.png)
- Remove extra spaces between string using REGEXP:
SELECT REGEXP_REPLACE
('Vikas Pandey from Delhi', '[[:blank:]]+', ' ')
FROM DUAL;
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2023/01/image-344-1024x332.png)