17,377
社区成员
发帖
与我相关
我的任务
分享
with t1(b1,b2)
as (select '01',1 from dual union
select '01',2 from dual union
select '02', 1 from dual union
select '02' ,2 from dual )
select * from t1 where regexp_substr(b1,'[^0]+',1,1)=b2
/* B1 B2
1 01 1
2 02 2
*/