Home » SQL & PL/SQL » SQL & PL/SQL » CONCATINATION MULTIPLE COULMN VALUES (oracle 8i (8.1.7.2.0), unix)
CONCATINATION MULTIPLE COULMN VALUES [message #277912] Thu, 01 November 2007 03:22 Go to next message
saipol
Messages: 4
Registered: November 2007
Junior Member
Hi all,

I need a sql, to get multiple rows data in a single row.

that data is like this.

data in table1

IDNO     TEXT
---------------
1        The
1        Netherlands
1        Europe
2        I 
2        am working for GE
3        This is 
3        a 
3        laptop


i need output like this


IDNO       TEXT
----------------
1           The Netherlands Europe
2           I am working for GE
3           This is a laptop


* table1 may contain non-equal number of rows for each IDNO.


[Updated on: Thu, 01 November 2007 03:34]

Report message to a moderator

Re: CONCATINATION MULTIPLE COULMN VALUES [message #277917 is a reply to message #277912] Thu, 01 November 2007 03:37 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

this has been answered n number of times.just search this forum.

hint : sys_connect_by_path. or you can go to www.sqlsnippets.com.


regards,
Re: CONCATINATION MULTIPLE COULMN VALUES [message #277924 is a reply to message #277917] Thu, 01 November 2007 04:11 Go to previous message
saipol
Messages: 4
Registered: November 2007
Junior Member
thanks got it.
Previous Topic: Filtering results where nth character is numeric
Next Topic: Long Sql used for Ref Cursor - Getting Invalid Identifier error
Goto Forum:
  


Current Time: Sun Dec 04 14:57:37 CST 2016

Total time taken to generate the page: 0.09633 seconds