Re: comma separated list
From: Ramesha H.G. Bhatta <r4hbhat_at_pacbell.com>
Date: 1996/09/09
Message-ID: <51262t$foa_at_gw.PacBell.COM>#1/1
Date: 1996/09/09
Message-ID: <51262t$foa_at_gw.PacBell.COM>#1/1
Hi,
you can use the following query,
select trim(column_a) || ' ,'|| rtrim(column_b) || ' ,'||column_c from <table_name>
Hope this solves your requirement,
Thanks,
Ramesha H.G. Bhatta
cindym_at_schdba00.sch.ge.com (CJM) wrote:
>Could someone please tell me how to select fields out of an oracle
>table in a comma separated list? For example, the table contains:
Received on Mon Sep 09 1996 - 00:00:00 CEST