oracle中使用正则:
select distinct regexp_instr('12345612345123',
'123',
LEVEL,
1)
FROM DUAL
WHERE regexp_instr('12345612345123',
'123',
LEVEL,
1) > 0
CONNECT BY LEVEL <= LENGTH('12345612345123')
oracle中使用正则,找出一段字段串,在另外一段字符串中出现的次数,及出现的位置
select regexp_instr('12345612345123','123',LEVEL,1),level,regexp_instr('12345612345123','123',LEVEL,1)
FROM DUAL
-- WHERE regexp_instr('12345612345123','123', LEVEL,1) > 0
CONNECT BY LEVEL <= LENGTH('12345612345123')