Re: How do I Select..?

Create a function, code follows. Likely to run pretty slowly ...

Create or replace function AllCities(namein varchar) return varchar is cursor main (cname varchar) is
 Select city
  from bogus
  where name = cname
  order by 1;
retval varchar2(2000);
Begin
For Rec in main (namein) loop
 retval := retval || rec.city;
End Loop;
Return(retval);
end;
/

SQL> Select Name, allcities(name) from (select distinct name from bogus);

NAME

Bill
BerlinBombay

Timma
BostonDCSanJose

Timma wrote:

> desc t;
> NAME varchar2(30);
> TEXT varchar2(4000);
>
> select * from t;Timma DC
> Timma SanJose
> Timma Boston
> Timma DC
> Bill Bombay
> Bill Berlin
>
> What I want is
> Timma SanjoseBostonDC
> Bill BombayBerlin
>
> How can I get this? Any help, appreciated
> Timma
Received on Fri Dec 21 2001 - 17:02:52 CST