17,377
社区成员
发帖
与我相关
我的任务
分享
WITH T AS
(SELECT 'XXXXXXXXXXXXXXXX[KKKK_PPPP]","RspType"XXXXXXXXXXXXXXXX' S
FROM DUAL
UNION ALL
SELECT 'XXX[XXXX]XXXXXXXXX[KKKK_PPPP]","RspType"XXXXXXXXXXXXXXXX' S
FROM DUAL
UNION ALL
SELECT 'XXXXXXXXXXXXXXXX[KKKK_PPPP]",asdfasdfa"RspType"XXXXXXXXXXXXXXXX' S
FROM DUAL)
SELECT S, S1, REGEXP_SUBSTR(S1, '[^_]+', 1, 1) K,
REGEXP_SUBSTR(S1, '[^_]+', 1, 2) P
FROM (SELECT S, REGEXP_REPLACE(S, '.*\[([^\[]+)\].*"RspType".*', '\1') S1
FROM T)