Learning Oracle SQL and PL/SQL
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment