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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Distinct string statement

Re: Distinct string statement

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 21 Feb 2005 15:20:07 -0800
Message-ID: <1109027833.416919@yasure>


Marina S. wrote:

> 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

Given that this is homework you will need to do a lot more than this to obtain help. Show us your work and we will hint you toward the solution.

PS: The Oracle version is essential for help.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Feb 21 2005 - 17:20:07 CST

Original text of this message

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