Oracle - 正则判断字段是否为同一数字组成
Oracle - 正则判断字段是否为同一数字组成
- 同一数字组成字段经过
regexp_replace(num,'(\w)\1{1,}','\1')
替换后,长度会变为1
with cte1 as
(
select '1111111111111' as num from dual union all
select '22222222222' from dual union all
select '23333333' from dual union all
select '4444' from dual union all
select '7777756666557' from dual
)
SELECT t.num,length(t.sss) FROM (
select num,regexp_replace(num,'(\w)\1{1,}','\1') as sss from cte1
) t
where length(t.sss) = 1;