Re: Distinct column content

"Thierry PLASSART" <thierry.plassart_at_wanadoo.fr> wrote in message news:<421a4ff9$0$3147$8fcfb975_at_news.wanadoo.fr>...
> Hi,
>
> I suggest to write a prg to fill a new table NEW_TABLE(ID,ID2,SingleSymbol),
> in order to obtain records like these:
> 11 1 abc
> 11 2 bbc
> 11 3 abf
> 11 4 cde
> 22 1 rda
>
> and so on... then, let's see...
>
> declare
> cursor CurSymbol is select distinct SingleSymbol from NEW_TABLE;
> counter number := 0;
> answer varchar(4096); -- will it be big enough ?
> begin
> for RecSymbol in CurSymbol
> loop
> if (counter = 0) then
> answer := RecSymbol.SingleSymbol;
> else
> answer := answer||','||RecSymbol.SingleSymbol;
> end if;
> counter := counter +1;
> end loop;
> end;
> dbms_output.put_line(answer);
> ;
>
>
> I agree the prg won't be very easy...
>
> Nevetheless, I hope it'll help!
>
> regards,
> Thierry
>
>
> "Marina S." <marina.sukhnev_at_thinknet.com> a écrit dans le message de
> news:440f14ee.0502211258.8f815af_at_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

Thank you Thierry,
I'll try it!

Marina Received on Tue Feb 22 2005 - 14:19:35 CST