OraFAQ Forum: SQL & PL/SQL » Split comma separated string (Merged)

Home » SQL & PL/SQL » SQL & PL/SQL » Split comma separated string (Merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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;

Report message to a moderator

Sql Problem [message #201167 is a reply to message #201162]

Thu, 02 November 2006 18:25

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

Report message to a moderator