Home » SQL & PL/SQL » SQL & PL/SQL » Complex String Query (Windows)
Complex String Query [message #293282] Fri, 11 January 2008 09:46 Go to next message
rameshbabupallapolu
Messages: 18
Registered: September 2005
Location: WA
Junior Member
Hi Experts,

Actually i am trying to seperate and print the string values. please find the below requirement.

My String is 'AA,B,C12,D33,E,F,G6666,H'

I am trying to print the each comma seperated column as separate line like

AA
B
C12
D33
E
F
G6666
H

Please give me any idea or query.

Regards
Ramesh
Re: Complex String Query [message #293285 is a reply to message #293282] Fri, 11 January 2008 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is just a pivot query that you'll easy find if you search.

Regards
Michel
Re: Complex String Query [message #293309 is a reply to message #293285] Fri, 11 January 2008 11:49 Go to previous messageGo to next message
rameshbabupallapolu
Messages: 18
Registered: September 2005
Location: WA
Junior Member
Hi Michel,

Please give me some guidence, how to seperate and print in seperate columns.

Regards
Ramesh
Re: Complex String Query [message #293310 is a reply to message #293309] Fri, 11 January 2008 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Click on Search button in menu bar, type pivot in the search field.

Regards
Michel
Re: Complex String Query [message #293356 is a reply to message #293282] Fri, 11 January 2008 14:56 Go to previous messageGo to next message
Volder
Messages: 38
Registered: April 2007
Location: Russia
Member
if you need just to print it, probably you don't need pivot for getting different result rows, you can simply
replace(str,',',CHR(10))
Re: Complex String Query [message #293359 is a reply to message #293282] Fri, 11 January 2008 15:40 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
start here

http://www.orafaq.com/node/1871

Kevin
Previous Topic: WITH Clause Help
Next Topic: Group together data from multiple columns
Goto Forum:
  


Current Time: Fri Dec 09 00:18:42 CST 2016

Total time taken to generate the page: 0.31227 seconds