Returning multiple rows as a single row

From: Dave Morgan <dave.morgan_at_cybersurf.net>
Date: Mon, 21 Jan 2002 13:55:09 -0800
Message-ID: <F001.003F6650.20020121133524@fatcity.com>

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