您不需要aDISTINCT
即可获得结果;此外,要获得给定顺序的结果,您所需要做的只是一个ORDER BY
子句:
select trim(regexp_substr('bbb;aaa;qqq;ccc','[^;]+', 1,level) ) as q
from dual
connect by regexp_substr('bbb;aaa;qqq;ccc', '[^;]+', 1, level) is not null
order by level
使用regexp_substr在Oracle中拆分字符串
您不需要aDISTINCT
即可获得结果;此外,要获得给定顺序的结果,您所需要做的只是一个ORDER BY
子句:
select trim(regexp_substr('bbb;aaa;qqq;ccc','[^;]+', 1,level) ) as q
from dual
connect by regexp_substr('bbb;aaa;qqq;ccc', '[^;]+', 1, level) is not null
order by level