1

Topic: Search of repeating values

Good afternoon, I will not think while, I need to find in the list of names for example at what 5 serial characters coincide. As it to issue, thanks

2

Re: Search of repeating values

[quote =] As it to issue

with t as (
select ' abcde12345 ' name from dual union all
select ' bcde1234567 ' name from dual union all
select ' qwecde123777 ' name from dual union all
select ' 12345678abc ' name from dual union all
select ' 678abcdeqwe ' name from dual
)
select t1.name, t2.name from t t1, t t2

Further experts on REGEXP will be tightened.