我有一个这样的问题
SELECT REGEXP_SUBSTR('SARAH;10,JOE;1D,KANE;1A,SDF:1a', '[^,;]+', 1, level)
FROM dual
CONNECT BY REGEXP_SUBSTR('SARAH;10,JOE;1D,KANE;1A,SDF:1a',
'[^,;]+',
1,
level) IS NOT NULL;
我想把o/p定为SARAH,JOE,KANE,SDF