oracle数据库split()方法的实现与测试 1 参考资料:http://sonic10101.iteye.com/blog/3941872 具体SQL:
select fn_split('1,2,3,4,',',') from dual;select t.* from (SELECT * FROM TABLE (CAST (fn_split ('1;;12;;123;;1234;;12345', ';;') AS ty_str_split)))t