select A,REGEXP_SUBSTR(B, '[^,]+', 1, LEVEL) B
from T
CONNECT BY LEVEL <= REGEXP_COUNT(B, '[^,]+')
and rowid= prior rowid
and prior dbms_random.value is not null;
from T
CONNECT BY LEVEL <= REGEXP_COUNT(B, '[^,]+')
and rowid= prior rowid
and prior dbms_random.value is not null;
版主太给力了!!谢谢版主!