Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Distinct column content

Distinct column content

From: Marina S. <marina.sukhnev_at_thinknet.com>
Date: 21 Feb 2005 12:58:33 -0800
Message-ID: <440f14ee.0502211258.8f815af@posting.google.com>


Hi,

I have some question,

I have table with 2 columns

id symbol

11   abc,bbc,abf,cde
22   rda,abc,aig
33   ibm,aig,sun
55   aig,klm,suk,sun
23   bbc,kln,sun,adf

.. ..
.. ..

I need to select distinct symbol strings from symbol column,they shoudn't be repeated,but should be comma separated as they appear in a column.
the result to user should be like:
abc,bbc,abf,cde,rda,aig,ibm,sun,klm,suk,kln,adf...

Any ideas are really appreciated,

Marina Received on Mon Feb 21 2005 - 14:58:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US