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
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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Asked yesterday.
Asked today.
Just search.
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: Problem with a query.
Next Topic: How to get the OS-User
Goto Forum:
  


Current Time: Wed Dec 07 16:12:25 CST 2016

Total time taken to generate the page: 0.09861 seconds