Hi everyone
My Database is Oracle 12c R 12.1.0.2
I am looking for a regular expression or Substr/Instr query to find repeating pattern from a long string and eliminate them
Input Output
9999 W San Brazil St Ste A Ste A:48:77774:4444 9999 W San Brazil St Ste A:48:77774:4444
with t as (
select '9999 W San Brazil St Ste A Ste A:48:77774:4444' addr from dual
)
-- end of on-the-fly data sample
select addr,
regexp_replace(addr,'^(.+?)\1*$','\1') sub_str
from t
above query doesn't return the Output I am looking for
Can someone please guide me
Thanks
J1604