Split comma separated string (Merged) [message #201162] |
Thu, 02 November 2006 17:28 |
pankyz
Messages: 11 Registered: October 2006
|
Junior Member |
|
|
Hi
Guys,I need your help .Suppose i have one line i.e Hello,world,Welcome,how,are,you,doing
i Just wanna display output
Hello
World
Welcome
How
are
you
doing
Thanks and regards
|
|
|
Re: Query Problem [message #201164 is a reply to message #201162] |
Thu, 02 November 2006 17:38 |
|
ebrian
Messages: 2794 Registered: April 2006
|
Senior Member |
|
|
select replace('Hello,world,Welcome,how,are,you,doing',',',chr(10)) from dual;
|
|
|
|
|
|
|
Re: Query Problem [message #201198 is a reply to message #201181] |
Fri, 03 November 2006 00:32 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Topics moved and merged.
Please do NOT post topics to more than one forum, and please start posting in the Newbie forum.
|
|
|