我给你个基本思路
你简单改改：
(SELECT 1 RN,
'1::张三::959923f5-6f31-4fb6-9647-d2403245eda0::2019-03-11 09:57:55::已核::同意::e2ztjsokq5un||2::李四::cdf0f5a6-6ce1-47d2-9ca5-214ceb740e5b::2019-03-11 09:59:44::已核::同意::e4lxjsokuxqi' I_NAME
FROM DUAL),
T1 AS
(SELECT RN,
LEVEL LV,
REPLACE(REGEXP_SUBSTR(I_NAME, '[^||]+', 1, LEVEL), '::', ' ') VAL
FROM T
CONNECT BY RN = PRIOR RN
AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
AND LEVEL SELECT VAL,
REGEXP_REPLACE(VAL,
'(.) (.*) (.*) (.*) (.*) (.*) (.*) (.*)',
'\6 \2 \4')
FROM T1
您试试~
望采纳~~~
