Home » SQL & PL/SQL » SQL & PL/SQL » how to show sinlge line text data in seperated column wise (Oracle 10g)
how to show sinlge line text data in seperated column wise [message #438377] Fri, 08 January 2010 08:21 Go to next message
sr_2407
Messages: 6
Registered: December 2009
Location: INdia
Junior Member
HI ,
   My requirement is ,
  How cna I show "xx yy zz tttt uuuu2"  in column wise .such as,
 xx
 yy
 zz
 tttt
 uuuu2
Re: how to show sinlge line text data in seperated column wise [message #438379 is a reply to message #438377] Fri, 08 January 2010 08:30 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select replace('xx yy zz tttt uuuu2',' ',chr(10)) from dual;
REPLACE('XXYYZZTTTT
-------------------
xx
yy
zz
tttt
uuuu2

1 row selected.

Regards
Michel
Previous Topic: Avoid breakup in the sequence
Next Topic: Format Excel Using PLSQL
Goto Forum:
  


Current Time: Thu Sep 29 12:25:25 CDT 2016

Total time taken to generate the page: 0.09839 seconds