Home » SQL & PL/SQL » SQL & PL/SQL » Names separated by "|" in a single line to individual names (Oracle10g)
Names separated by "|" in a single line to individual names [message #306958] Mon, 17 March 2008 06:35 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
I have a string where the names are separated by "|"

e.g.,

"china|india|france|japan|italy|germany|.|.|."

I need to process each of the names in a FOR LOOP in PL/SQL....

How to achieve it ? Is it feasible ?







[Updated on: Mon, 17 March 2008 06:40]

Report message to a moderator

Re: Names separated by "|" in a single to individual names [message #306961 is a reply to message #306958] Mon, 17 March 2008 06:36 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible.
Search for "varying in list".

Regards
Michel
Previous Topic: count in dynamic SQL (merged 2)
Next Topic: Transaction control in plsql
Goto Forum:
  


Current Time: Mon Dec 05 15:09:29 CST 2016

Total time taken to generate the page: 0.09662 seconds