17,082
社区成员
发帖
与我相关
我的任务
分享
with t as
(
select '1010 3576 1234 123' id from dual union all
select '1010 3576 1234123' id from dual union all
select '1010 35761234 123' id from dual union all
select '1010 3576 1x34 123' id from dual union all
select '1010 2576 1234 103' id from dual union all
select '1010 35761234123' id from dual union all
select '1010 3576 0234 123' id from dual
)
select * from t where regexp_like(id,'1010 3576 [[:digit:]]{4} [[:digit:]]{3}');
'^1010 3576 [0-9]{4} [0-9]{4}$'