Re: comma separated list
From: Garry M. Filimonov <garry_at_fly.triniti.troitsk.ru>
Date: 1996/09/09
Message-ID: <01bb9e6c$606f8b00$bf0000c5_at_Garry.triniti.troitsk.ru>#1/1
Date: 1996/09/09
Message-ID: <01bb9e6c$606f8b00$bf0000c5_at_Garry.triniti.troitsk.ru>#1/1
CJM <cindym_at_schdba00.sch.ge.com> wrote in article
<CINDYM.96Sep9113304_at_schdba00.sch.ge.com>...
> Could someone please tell me how to select fields out of an oracle
> table in a comma separated list? For example, the table contains:
> Column A Column B Column C
> -------- -------- --------
> firstval value1 valuea
> 2ndval val2 valb
>
> I want my output to be:
>
> firstval, value1, valuea
> 2ndval, val2, valb
>
select ColumnA || ',' || ColumnB || ',' || ColumnC from ....
-- G'luck ! ----------------------------------------- Garry M. FIlimonov LASU TRINITI, Troitsk, MO, Russia garry_at_triniti.troitsk.ruReceived on Mon Sep 09 1996 - 00:00:00 CEST