oracle数据库split()方法的实现与测试
1 参考资料:http://sonic10101.iteye.com/blog/394187
2 具体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 发布时间： 2012-07-15 20:20:06 作者： rapoo
oracle数据库split()方法的实现与测试
1 参考资料:http://sonic10101.iteye.com/blog/394187
2 具体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