SQL如下:
SELECT regexp_substr('1@2@3@4','[^@]+',1,level) value
FROM dual
CONNECT BY level <= LENGTH('1@2@3@4')-LENGTH(REPLACE('1@2@3@4','@',''))+1;
结果如图:
其它方法参见:
SQL如下:
SELECT regexp_substr('1@2@3@4','[^@]+',1,level) value
FROM dual
CONNECT BY level <= LENGTH('1@2@3@4')-LENGTH(REPLACE('1@2@3@4','@',''))+1;
结果如图:
其它方法参见: