Skip to Main Content
Forums

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 a string to rows

670254Jan 6 2009 — edited Jan 6 2009
gurus,
how to split a string for eg , select ('test;tester;%siteconfidence%;') from dual into
test
tester
siteconfidence

using sql

Note: ';' is the delimeter
ingnore any wild card chars of the string like '%' and only return the characters

Edited by: user10600431 on 06-Jan-2009 06:33
This post has been answered by 666352 on Jan 6 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2009
Added on Jan 6 2009
9 comments
9,624 views