Home » SQL & PL/SQL » SQL & PL/SQL » Split comma separated string (Merged)
Split comma separated string (Merged) [message #201162] Thu, 02 November 2006 17:28 Go to next message
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 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
select replace('Hello,world,Welcome,how,are,you,doing',',',chr(10)) from dual;
Sql Problem [message #201167 is a reply to message #201162] Thu, 02 November 2006 18:25 Go to previous messageGo to next message
pankyz
Messages: 11
Registered: October 2006
Junior Member

I have a line like Hi,how,are,you,doing
i want to display iike this
hi
how
are
you
doing

The line may be of any number of words
plz tell me how to do it
Re: Sql Problem [message #201169 is a reply to message #201167] Thu, 02 November 2006 19:25 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Pipelined function - search for that.
Re: Sql Problem [message #201171 is a reply to message #201167] Thu, 02 November 2006 20:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Duplicate post here.
Re: Query Problem [message #201181 is a reply to message #201162] Thu, 02 November 2006 21:33 Go to previous messageGo to next message
pankyz
Messages: 11
Registered: October 2006
Junior Member

Thanks for your reply ...can we store these values in the variables...
thanks
Re: Query Problem [message #201198 is a reply to message #201181] Fri, 03 November 2006 00:32 Go to previous message
Frank
Messages: 7880
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.
Previous Topic: adding quotes
Next Topic: Procedure Syntax
Goto Forum:
  


Current Time: Fri Dec 02 16:42:58 CST 2016

Total time taken to generate the page: 0.32174 seconds