Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Returning multiple rows as a single row
Hi All,
I know I've seen this before but I forget ... Given a table like
Customer_Software(
Custid Number Software Varchar
How do I return the customerid and all the software entries in a single
row?
Desired output is like
Custid
1 Excel Word StarOffice 2 vi tgif oracle
I know it's a group by with a subquery but ....
TIA
Dave
--
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
INET: dave.morgan_at_cybersurf.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 21 2002 - 15:55:09 CST