如下:
select regexp_substr(a.ip, '[^.]+', 1, 1) ip1,
regexp_substr(a.ip, '[^.]+', 1, 2) ip2,
regexp_substr..., 'C.t', 1, 1) 'Occurrence 1',
REGEXP_INSTR('Cat City is SO Cute!'..., 'C.t', 1, 1, 0) 'Occurrence 1',
REGEXP_INSTR('Cat City is SO Cute!'..., 'C.t', 1, 1, 1),
REGEXP_INSTR('Cat City is SO Cute!'..., 'C.t', 1, 2, 1),
REGEXP_INSTR('Cat City is SO Cute!'