tag:blogger.com,1999:blog-7631414.post109785230924781296..comments2023-05-31T04:00:19.993+00:00Comments on Tony Andrews on Oracle and Databases: Parsing delimited fields in a character stringTony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7631414.post-15346545527672554512019-08-29T23:03:47.085+00:002019-08-29T23:03:47.085+00:00Beautiful!! Exactly what I needed. Thanks Jason!Beautiful!! Exactly what I needed. Thanks Jason!Anonymoushttps://www.blogger.com/profile/00383530906704258258noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-53813178491708461712009-03-11T20:50:00.000+00:002009-03-11T20:50:00.000+00:00Here is one that is recursive and in a single func...Here is one that is recursive and in a single function:<BR/><BR/>CREATE OR REPLACE FUNCTION getStringElement(p_string VARCHAR2,<BR/> p_element NUMBER,<BR/> p_delimiter VARCHAR2 := ',',<BR/> p_level NUMBER := 0) RETURN VARCHAR2<BR/>IS<BR/><BR/> v_string VARCHAR2(2000) := NULL;<BR/> v_element Jason Bennetthttps://www.blogger.com/profile/00022840605182576056noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-1146609912369465522006-05-02T22:45:00.000+00:002006-05-02T22:45:00.000+00:00Simple, efficient, GREAT! Thanks...Simple, efficient, GREAT! Thanks...Anonymousnoreply@blogger.com