OraFAQ Forum: SQL & PL/SQL » parse ';' from list of strings and return the substring

Home » SQL & PL/SQL » SQL & PL/SQL » parse ';' from list of strings and return the substring (Oracle)

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

parse ';' from list of strings and return the substring [message #355841]

Mon, 27 October 2008 23:13

want_to_know
Messages: 1
Registered: October 2008

Junior Member

I have records like shown below:

'abc;xyz;mno'
i want to parse ';' and get like below

abc
xyz
mno

i have to compare name='abc'
name='xyz'
name='mno'

where name is some other field.

How can i do this?

Thanks in advance

Report message to a moderator

Re: parse ';' from list of strings and return the substring [message #355847 is a reply to message #355841]

Mon, 27 October 2008 23:55

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

AskTom: varying elements in IN list
T.Kyte blog: http://tkyte.blogspot.com/2006/06/varying-in-lists.html

Regards
Michel

Report message to a moderator

Previous Topic:	select from a table minus other table?
Next Topic:	what the (+) means?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 13:38:44 CST 2024