Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Split Comma Delimited String Oracle

722885Sep 16 2009 — edited Jul 27 2012
I want to Split Comma Delimited string in oracle9i into rowwise data.i do not want to use Functions or connect by level...
is there any other way from which we can split strings.???

if we use Connect by level method the problem im facing is we cannot use suqueries in Connect by clause...

Edited by: user11908943 on Sep 16, 2009 8:37 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2012
Added on Sep 16 2009
19 comments
45,243 views