Tuesday, May 17, 2016

How to remove repeated character from string

By using  regular experssion it is possible to remove repeated characters from string

Example
select regexp_replace('Tesstt', '(.)\1+','\1') 
  from dual;
Result: Test

No comments:

Post a Comment