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


Current Time: Mon Nov 04 06:25:42 CST 2024