SQL QUERY

From: Pallav Kalva <pallav_at_starmedia.net>
Date: Sun, 19 Aug 2001 21:41:54 -0700
Message-ID: <F001.0037062E.20010819213527@fatcity.com>

Hi List,

    I need an help on sql query, have a table with the following data

       OID INTEREST
---------- ----------

       100          1
       100          2
       100          3
       100          4

    I want the output to be displayed as

    OID INTEREST
    100 1,2,3,4

    is it possible thru sql or pl/sql ?

Thanks!
Pallav

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Pallav Kalva
  INET: pallav_at_starmedia.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 Sun Aug 19 2001 - 23:41:54 CDT