Wednesday, November 20, 2019

Remove Special Character From A String Using REGEXP_REPLACE

SELECT REGEXP_REPLACE('test'dssdf/sdfs','[^a-z_A-Z ]') FROM DUAL

RESULT : testdssdfsdfs

No comments:

Post a Comment