Monday, May 23, 2016

How to find repeating substring within string

By using regular expression it is possible to find repeating substring within string

select 
        regexp_replace('telltell','^(.+?)\1*$','\1') sub_str

  from  dual

No comments:

Post a Comment