Home » SQL & PL/SQL » SQL & PL/SQL » How to convert row into columns
How to convert row into columns [message #329924] Fri, 27 June 2008 01:31 Go to next message
shakti.singh
Messages: 4
Registered: June 2008
Junior Member
in the table values is looks like...
col1
abc,def,gh,tuy

i want to display like....
col1
abc
def
gh
tuy

Regards,
Shakti
Re: How to convert row into columns [message #329927 is a reply to message #329924] Fri, 27 June 2008 01:37 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
I would use UNPIVOT.
Re: How to convert row into columns [message #329929 is a reply to message #329924] Fri, 27 June 2008 01:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's a starting point:
http://www.orafaq.com/forum/m/285231/102589/?srch=instr+substr+dual#msg_285231

Regards
Michel
Previous Topic: display recods in cross format
Next Topic: Sql 10% data only..
Goto Forum:
  


Current Time: Sat Dec 03 06:07:59 CST 2016

Total time taken to generate the page: 0.10592 seconds