Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Pivoting Rows into a SINGLE column
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
would it be possible to get an output like:
ID PHONES
---------- ----------------
1 123, 456, 789 2 234, 567
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