Home » SQL & PL/SQL » SQL & PL/SQL » parse ';' from list of strings and return the substring (Oracle)
parse ';' from list of strings and return the substring [message #355841] Mon, 27 October 2008 23:13 Go to next message
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
Re: parse ';' from list of strings and return the substring [message #355847 is a reply to message #355841] Mon, 27 October 2008 23:55 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: select from a table minus other table?
Next Topic: what the (+) means?
Goto Forum:
  


Current Time: Sat Dec 03 22:36:04 CST 2016

Total time taken to generate the page: 0.09218 seconds