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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
