Home » SQL & PL/SQL » SQL & PL/SQL » Need to Split select statement column output into multiple lines (Oracle,10.2.0.2,solaris)
Need to Split select statement column output into multiple lines [message #286118] Thu, 06 December 2007 08:53 Go to next message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Hi All,

I need help on this issue.
I have one address column with varchar(2000) length,i need to split the output into multiple lines when i query for that.
Ex:address:1551 park ave,Minneaplis,55404,US(this o/p for single column)
I need output in multiple lines like below
1551 park ave
Minneapolis
55404
US


Thanks
sheker

Report message to a moderator

Re: Need to Split select statement column output into multiple lines [message #286119 is a reply to message #286118] Thu, 06 December 2007 08:58 Go to previous message
Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Asked yesterday.
Asked today.
Just search.
Closed.
/forum/fa/448/0/
Regards
Michel

Report message to a moderator

Previous Topic: Problem with a query.
Next Topic: How to get the OS-User
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 20 08:51:22 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.