REGEXP_REPLACE Function :
It will allow you to replace a sequence of characters in a string with another set of characters using regular expression pattern matching.
SELECT regexp_replace('Removing_Special - Characters .,_-$%&^& ',
'[^0-9 A-Za-z]', '');
OR
Update emp2 set Ename = Regexp_Replace (Ename,'[^A-Z0-9 ]', '');
It will allow you to replace a sequence of characters in a string with another set of characters using regular expression pattern matching.
SELECT regexp_replace('Removing_Special - Characters .,_-$%&^& ',
'[^0-9 A-Za-z]', '');
OR
Update emp2 set Ename = Regexp_Replace (Ename,'[^A-Z0-9 ]', '');
No comments:
Post a Comment