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: 64840
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: Sat May 27 22:06:02 CDT 2017

Total time taken to generate the page: 0.05896 seconds