Pivoting Rows into a SINGLE column

From: atta ur-rehman <atta707_at_hotmail.com>
Date: 2 Aug 2001 22:06:17 -0700
Message-ID: <6e453d75.0108022106.25e3f0a5@posting.google.com>

Bowing to the genius of the gurus...

Dear all,

Given a table:

SQLWKS> select * from phone;
ID PHONE
---------- ----------------

         1 123             
         1 456             
         1 789             
         2 234             
         2 567             

5 rows selected.

would it be possible to get an output like: ID PHONES
---------- ----------------

         1 123, 456, 789
         2 234, 567

2 rows selected.

and that too by using plain, vanilla flavoured SQL i.e. No PL/SQL function involved. Its on Oracle 8.1.6, Windows NT 4.

Thanks in anticipation for your precious words.

Regards,

:) ATTA Received on Fri Aug 03 2001 - 00:06:17 CDT