Re: Distinct string statement

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)